Copy First Sheet of Multiple Workbooks in Folder to One Workbook

Hi,

I would like to copy the first sheet only of multiple workbooks saved in a folder into one workbook using a macro.

A few conditions:

• The first sheet will have multiple names in these workbooks saved in the folder.
• I would like it so the workbook the sheets will be copied into can be saved in the same folder so the source folder address doesn't have to be changed however if not possible / too hard not a problem. https://www.got-it.ai/solutions/exce...ne-excel-sheet This one is good because you can select the files in a dialogue however it copies every single sheet.
• The workbook has these sheets all coped in as various sheets in the destination workbook. Not data all combined into one sheet in destination workbook.
• I am using Excel 2013.

I have tried a few codes I have found online and they don't seem to be working. For example I tried this one and no options given worked and the sheets themselves weren't even copied in.https://www.extendoffice.com/documen...workbooks.html I also tried https://www.excelforum.com/excel-pro...-workbook.html and the code in Post #5 but it also did not work.

If anyone could help or at least point me in the right direction that would be greatly appreciated.

Regards,
GC