Consolidation Macro

[Chris86t]

Hi There,

I have multiple spreadsheets that I want to Consolidate into one. I have a macro to do this where it's just one tab per spreadsheet, however I need one that does it across multiple tabs & multiple spreadsheets. Obviously the tabs are all different names which is another difficulty I'm facing. Appreciate it's not the best way to do it however I't the way I have to do it due to requirements of the users.

The column headers and column range is the same across all tabs and spreadsheets.

Can anyone out there help me?

Many thanks
C

 

[mumps]

Are you saying that you have multiple files with multiple sheets in each one and that you want to copy all the sheets in all the files into one Workbook? If this is the case, are all the source files open or does the macro have to open them. If the macro has to open them, what is the full path to the folder containing the source files? What is their extension (xlsx, xlsm)? Are the source files the only files in that folder?