Hi Jeff,

See Ron de Bruin's sample code at:

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

See particularly Sub Example11 on that page.

---
Regards,
Norman



"Jeff" wrote in message
...
Good morning all,
I have 5 to 8 workbooks in a folder called Class. The workbooks will not
always have the same name but they will only contain one sheet in each
book.
I would like to copy that sheet from each workbook into the current
workbook.
Is there a way to copy all sheets from all workbooks from a folder such as
c:\class.