|If all you need is to add the data from the new sheets to the summary sheet, and not worry about updating existing data from sheets that already existed, then some fairly simple VBA would probably handle it.|
Assuming the sheet names match (exactly) some data in the summary sheets, such as addresses in Column A, then the code could loop through the sheets and compare the sheet names to the list of addresses. If it can't find a sheet name in the list, then it would copy that sheet's data to the summary sheet.
Even easier would be if there were 4 addresses in the summary sheet and 4 sheets on Monday, but 4 addresses in the summary sheet and 7 sheets on Tuesday, then the code could just copy over the data from the last 3 (new) sheets.
This all depends on the layout of your sheets, the workbook, etc.
If you can see where I'm headed with my suggestions, then perhaps you can tell us how the sheets are laid out that might make something like one of those (or something else) possible.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.