Here is the long and short of my problem. There are 7 workbooks with
one worksheet each that are updated weekly and sent to a single
person. There will be a master summary workbook that will display the
values in each of the 7 workbooks on a single sheet. The master
workbook will also need to retain the values from the prior week for
comparison. This will need to be done with no user changes to the
formulas or resaving of workbooks. Any help that can be provided
would be great. Thanks!

Sounds like you need to create a macro that places the data in a database
type setup on a weekly basis. Then you rsummary sheet can draw from that
data using a pivot table.

Saving is only required if you want to retain information. So if that is
not the case, there is no reason to ever save.

--
Regards,
Tom Ogilvy

"Sales26" wrote in message
om...
Here is the long and short of my problem. There are 7 workbooks with
one worksheet each that are updated weekly and sent to a single
person. There will be a master summary workbook that will display the
values in each of the 7 workbooks on a single sheet. The master
workbook will also need to retain the values from the prior week for
comparison. This will need to be done with no user changes to the
formulas or resaving of workbooks. Any help that can be provided
would be great. Thanks!