Hi Kelly

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kelly" wrote in message ...
I have multiple workbooks each of which contains a great deal of data that is
summarized on a single sheet within each workbook. I am trying to
consolidate each of these "summary" sheets into a single seperate workbook.
I have structured the workbooks into directories within windows and would
like to build a macro that will be able to open every workbook in the
directory (one at a time) and copy the sheet I need into my new workbook .
Any thoughts?

Oh yeah each workbook has a different name and each directory has a
different number of workbooks.