Copying Several Workbooks into one Workbook as Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top