Macro to Copy/Paste from multiple Workbook

[p9j123]

Hello Experts,

I need help on the following.

I have a masterfile.xlsx that collects data from multiple excel file that were stored in C:/Source/Week 1.


I need a macro that will open each and every excel file from C:/source and copy the content from Summary Report Sheet columns R7:W? and paste it to the next blank row on masterfile.xlsx.


Condition:


1. Path should be captured from cell (A1) so that I can change it depending on the week period folder.
2. Macro will only copy the rows until the word "Reserve" so for exaxmple "reserve is on R12, then the macro will only copy R7:W11.

 

[p9j123]

by the way, the macro should be run from Masterfile.

 

[p9j123]

SOS please