Merging Excel files of same name (number formats - e.g. 30, 33, 44, 54) from different folders into a master file for each name

[cesarfaria]

Hello, gentlemen!

Here is the situation... Hope you guys can help me!

1. Objective

• Compile multiple reports (with the same name) from different "month folders" which are inside "year folders" into a Master file: "Database";
• The 2020 "year folder" does not have "month folders" inside and the reports are directly uploaded inside;
• The 2021 "year folder" have "month folders" inside and the reports are uploaded for each month;

2. Logic

• Each report has the following structure:

• For each report, it is needed to collect the entire row just for the rows with WHOLE NUMBERS in column A "Código":

• The output for the macro should be at thew worksheet "Compilation Base" inside the Master file "Database" like shown below:

3. Observations

• Every time I run the macro, the worksheet "Compilation Base" inside my Master file should clean up the worksheet and re-fill the data if there are new month folders created;
  • It is completely possible to change my "Month folder" names to number ones - e.g. Janeiro -> 1, Fevereiro -> 2, and so on...;

I believe that's all the information.

I really hope someone can help me with this one... I am really stucked where to start..

Thank you all.

C. Faria

 

[cesarfaria]

Guys, just correcting the observation...

3. Observations

• Every time I run the macro, the worksheet "Compilation Base" inside my Master fileshould clean up the worksheet and re-fill the data if there are new data, for example new month folders created with data;
  • It is completely possible to change my "Month folder" names to number ones - e.g. Janeiro -> 1, Fevereiro -> 2, and so on...;