Dear Excel-experts,

I have a VBA question.

Context:
- I have multiple Excel files with exactly the same layout.
- All Excel files are saved in one folder (C:\Temp\SourceFolder\*.xlm).
- Each Excel-file has 12 sheets (tabs) with month names included, such as: (2022 (1) - 2022 (2) - 2022 (3) – 2022 (4) – 2022 (5), and so on. Until the 12th month, December (2022 (12)….

What I like to achieve/have is:
- An input box with the question which sheet (tab) I like to read from all files in the source folder. For example: Which sheet you want to read? Input is (2022 (1) or 2022 (2) or 2022 (3) or a different month;
- Read the first and second columns from all Excel source-files that are placed in that specific folder (C:\Temp\SourceFolder\*.xlm).

- Make a copy of both rows (first en second one). This means per Excel-file from the source folder (C:\Temp\SourceFolder\*.xlm) and copy this information into one Excel-destination file (C:\Temp\Excel_Total_Result.xlm or something).
- Put all columns (first en second one) next to the other in the destination file (when finished, save the result).

Result: 1 destination file with all first and second columns read (from all files from the source folder), that are put next to each other in one destination file/sheet (like a summary).
Is this easy to create?

Thank you very much for any help provided. :-)


Best regards,

Hans