Combine Multiple worksheets based on Tab name from different files

%3CLINGO-SUB%20id%3D%22lingo-sub-2402161%22%20slang%3D%22en-US%22%3ECombine%20Multiple%20worksheets%20based%20on%20Tab%20name%20from%20different%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2402161%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%E2%80%99m%20looking%20for%20help%20to%20combine%202%20files%20with%20approx%2070-100%20worksheets%20in%20each%20workbook%20but%20each%20worksheet%20must%20be%20combined%20with%20a%20specific%20match.%3C%2FP%3E%3CP%3EFor%20example%26nbsp%3B%3C%2FP%3E%3CP%3EFile%20A%20has%20worksheets%20A%20to%20Z%20and%20continues%3C%2FP%3E%3CP%3EFile%20B%20has%20worksheets%201%20to%20100%3C%2FP%3E%3CP%3EI%20need%20the%20data%20from%20worksheet%20A%20to%20be%20matched%20with%20worksheet%201%2C%20B%3D2%2C%20C%3D3%20and%20so%20on.%3C%2FP%3E%3CP%3EThey%20are%202%20different%20types%20of%20data%20and%20formats%20and%20I%20want%20the%20data%20from%20worksheets%201-100%20to%20sit%20below%20the%20data%20already%20on%20sheets%20A%20to%20Z.%3C%2FP%3E%3CP%3EI%E2%80%99m%20using%20Excel%202016%20on%20Windows%20PC%20with%20no%20option%20to%20change%20either%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20greatly%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2402161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi

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