Hi DaveServo
Now I understand what you are after.
Firstly you can update a summary workbook automatically. However there are certain caveats you need to bear in mind.

1. You would have to have static workbook names for the daily workbooks.
2. They need to be stored on the same network as the summary workbook.
3. You must not change the location of the daily workbooks once you have set them up and produced the for mulae in the summary workbook. If you do the automatic updates will not work.

The summary workbook will be updated automatically when a daily workbook is updated/changed. Here is the formula you need to put into the summary workbook:

=[DailyWorkbookName]SheetName!$A$1

Copy this formula to a separate cell for each daily workbook you wish to summarise.
Replace DailyWorkbookName with the correct workbook name.
Replace SheetName with the correct worksheet name.
Replace $A$1 with the correct cell reference in each daily workbook.

An easier way to create the Summary workbook formulae is to click on the cell where the Daily Total is stored and right click and select copy.
Click in the cell in the Summary Workbook where you want top store the updates and right-click and select paste link.
This will create the formula for you.
Once you have copied all the links for each daily worksheet save the Summary workbook and close it. Any updates done on the daily workbook will automatically update the summary workbook even if it is closed.

REMEMBER - DO NOT CHANGE THE LOCATION OF ANY OF THE WORKBOOKS AFTER YOU HAVE CREATED THEM.

Tony