Jay-
Will the source data files always be directly accessable from their "active"
location (e.g. on a server or your personal machine) or will copies of those
workbooks be sent to you as updates, for example by email?

If they are in a live location, and someone has it open when you are ready
to run your report, do you want to grab the data as it was when the file was
last saved, or wait until the next time the file is closed (assuming the
active user remembers to close it)?

Are the daily reports dependent on other processes (other files, systems,
etc) or could you potentially keep them permanently in your workbook, and
only expose the weekly report when you need to run it?

:-)
Keith

"Jay" wrote in message
...
hi,

i need to create a weekly report pulling data from a
series of 6 daily reports which each exist in their
own .xls document. i want to create a macro to do this
automatically

what's the best way for me to access the data? should i
copy it into hidden tabs in my weekly report, or call it
directly from the existing files.

i would like to be able to enter the week ending date
(let's say "i"), and then have excel automatically gather
the week's data (i-0,1,2,3,4,5)which will populate the
formulas i create on the weekly page.

i'm just beginning my vba foray and would greatly
appreciate any help. thanks