Hi everyone,
I would like to create a macro to consolidate multiple files in one masterfile but to collect the information by sheet.
For example
File 1.xls has 2 sheets Austria, Belgium
File 2.xls has 3 sheets UK, Austria, France
File 3.xls has 5 sheets Austria, Belgium, France, Netherlands...