generate report - consolidation macro

Dear,

I would like to receive some help with following macro...
I have a master report file : UAT_TEST_CASES_MASTER for which I want to generate a report based upon other input sheets (for example UAT_TEST_CASES_XXX, UAT_TEST_CASES_YYY, ...)

the macro should:
- be included into the master test cases
- insert pop-up message which file to use as input to copy to master file
- copy all lines looping all worksheets of the input file where the column test executor (column I) is completed with a value and pasting it to the same worktab (same name in master).
- when running the macro for multiple users, the macro should not overwrite the lines but continue where the last line was injected.

Objective: to make a consolidation of different input files into one master file.

I hope this is more or less clear
I attach in attachment both example files.

Thanks in advance for your promt assistance!

Erik