Try this example

http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"bluebanker" wrote in message ...
Every day for the last 3 years, my co-worker has saved a file with
similar information under the same dirctory, naming it after the day
(20030619.xls). How do I pull all this data in on one spreadsheet, I
just cells A4:H8 from everyday of the past 3 years to appear on one
sheet. Totally new to VBA. Is there a way to save all these workbooks
as tabs (by day) or a simpler way?

Thanks for your help.