Combine sheets with same name from different workbooks into new sheet

Blessy Clara

Board Regular
Joined
Mar 28, 2010
Messages
193
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,099,017
Messages
5,466,051
Members
406,461
Latest member
Garrus

This Week's Hot Topics

Top