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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,099,184
Messages
5,467,112
Members
406,524
Latest member
pascalschurink

This Week's Hot Topics

Top