Combine Multiple worksheets based on Tab name from different files

Regular Visitor


I’m looking for help to combine 2 files with approx 70-100 worksheets in each workbook but each worksheet must be combined with a specific match.

For example 

File A has worksheets A to Z and continues

File B has worksheets 1 to 100

I need the data from worksheet A to be matched with worksheet 1, B=2, C=3 and so on.

They are 2 different types of data and formats and I want the data from worksheets 1-100 to sit below the data already on sheets A to Z.

I’m using Excel 2016 on Windows PC with no option to change either format.


Any help greatly appreciated

0 Replies