Temp File
 

Happy Holidays! Does anyone have any suggestions on how
to take select information from multiple reports (in
Excel) and put that information into a temporary file
(Excel)and hold it until I am ready to use it for a mass
report? I want the information update everytime I run
one of the reports.

The reason that I am needing this is because I have five
different reports that I run on a monthly basis. I want
to take select information from each of those reports and
put it into one big report. I want the temporary file to
update when I run one of those five reports. Each report
needs to be on a separate sheet. I need the sheet to
update when I run the small report. When this update is
done, I don't want to override the file, I want to
override the sheet. Then, I want to create a macro to
retreive the information from the temporary file.

Are there any suggestions on how to get this started?
Any help would be greatly appreciated. Thanks in advance!

Julie