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.