Combine sheets with same name from different workbooks into new sheet

[Blessy Clara]

Hi

I have a folder with many excel workbooks

Each workbook has multiples sheets - Each sheet is named from A to Z (Sheet A, Sheet B ....Sheet z)
The header, sheet names are all in the same order and name in all workbooks

I want to combine all sheets based on the sheet name from different workbooks into a new Excel file

Example

Workbook - 1 - sheet A + workbook 2 sheet A + workbook 3 sheet A....etc - as a single sheet NEW Excel FILE A
Workbook - 1 - sheet B + workbook 2 sheet B + workbook 3 sheet B-...etc as a single sheet NEW Excel FILE B

Basically I would like to consolidate/merge all sheets with "similar name" from different workbooks in to a new excel file
So i will have a new excel sheet/file named A which has all sheets named A from different workbooks combined as a single sheet
likewise for all sheets from A to Z

Thank you in advance - Any help would be very useful

 

[alansidman]

HEre is a tutorial on Power Query for combining tables.

https://trumpexcel.com/combine-data-from-multiple-workbooks/