Hello all! I recently posted a message, but got no
response. I was wondering if anyone could get me started
on this. Any suggestions would be appreciated. I have
several reports that I want to take select information
from (all in Excel format) and put that information into
a temporary file (Excel preferably)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? I
need to somehow create link between the temporary file
and the five reports that I run every month. Any help
would be greatly appreciated. Thanks in advance and
Happy Holidays!

Julie