Logging information across different spreadsheets w/out repitition

Since you have not answered if the name and address combination is unique I have made the assumption it is since you call this person customer.
I came back on my idea about deleting the weekdays and days column contents after processing.
The file now works, duplicates are avoided in the same week.
If you decide to add another day like Bob 1, 3 and you decide on 1, 3, 2 or you just change that to 4 it will add Bob to that weekday 4

I added a button to Clear all data which takes care of clearing the weeks for a new period of 4 weeks.
I have not added comments to the vba code but first give it a run and we'll see.
I deleted all the empty rows of the table just insert a new table row to add no customers (you know how that works with tables, tight?

Have fun with it.