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!