dynamic VBA - copy cells from different files to the master one

[afgi]

I have a macro (pls see attached file) that aggregates data from files located in specific destination. I have managed to setup a macro that copies from particular sheet and particular range of cells.

I need to upgrade this macro to:
• I don’t want it to create new workbook, but i need it to overwrite existing workbook in particular sheet – i just need to update it.
• Can I ask VBA to copy cells from more than one range? Range mentioned in VBA code now is “B1:M7”, I need also “B8:M14”

[afgi]

??????????????????