Consolidating multiple files per sheet

[kiki_xy]

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, Sweden

The masterfile I would like to create sheets per each country and consolidate the information per each Country, all the information from Austria to be copied to Austria, Belgium to Belgium, etc.

I saw various solutions of consolidation of files but no solution per consolidating per sheets.

Thank you in advance.