Copying Several Workbooks into one Workbook as Worksheets

[Blue_Crystal]

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.

 

[Ron de Bruin]

Try this example

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

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