Try this example

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

See this example
http://www.rondebruin.nl/copy3.htm#sheet


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



"Blue_Crystal" wrote in message ...
I have several Workbooks in a folder. Each Workbook has only one Worksheet.

How can I copy all the Workbooks into one Workbook with as many worksheets
as there were Workbooks in the folder?

Thanks.