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