Consolidate Data from other workbooks
 

I get weekly reports from 13 different sites that I save together in one
folder. All reports are done on the same template so data is in the same
ranges for each report. Each report will have a different file name. Not all
sites may send a report. I want to create a Master Report to be included in
the same folder that has the data sums from the other reports. I would think
it best that this Master be the same blank template that the reports use and
consolidate to the same ranges. I will also want to add to the Master, the
file names of the site reports so there is a list of which sites submitted a
report for this Master.
Any pointers on how to start a macro for the Master Report would be
appreciated.

TIA.. Mike F

Consolidate Data from other workbooks
 

Maybe you can use this Mike
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mike Fogleman" wrote in message ...
I get weekly reports from 13 different sites that I save together in one
folder. All reports are done on the same template so data is in the same
ranges for each report. Each report will have a different file name. Not all
sites may send a report. I want to create a Master Report to be included in
the same folder that has the data sums from the other reports. I would think
it best that this Master be the same blank template that the reports use and
consolidate to the same ranges. I will also want to add to the Master, the
file names of the site reports so there is a list of which sites submitted a
report for this Master.
Any pointers on how to start a macro for the Master Report would be
appreciated.

TIA.. Mike F