Loop-through Macro

[ryansm05]

Hi,

I'm wondering if anyone can help me with the below?

I have 2 files (Client X & Client B). They are saved in the following folder: I:\Content & Creative\Design Admin\_Revenue

Additionally, I have my summary file (which does not yet have a macro - but this is where I'm wanting the macro to work). I'm needing specific cells to be copied from the files in the above location, and then pasted into the summary file. This summary file location is: I:\Content & Creative\Design Admin\_Revenue\Summary

Data to be copied from each client file (Client X & Client B)

Cell D3
Cell D6
Cell E10
Cell E11
Cell E12
Cell E14

Data to be pasted to the summary file:
(D3) to D6
(D6) to E6
(E10) to G6
(E11) to H6
(E12) to I6
(E13) to J6


If this is possible, it would be good to then sort this data in the summary file by column E (client). In addition, when I re-run the macro, data may have been updated or files even removed. Therefore, I will need it to clear the summary sheet each time and start afresh.

I have uploaded the 3 files mentioned to dropbox:
Client X: https://www.dropbox.com/s/4nqla0mjrxlzwe3/Client X.xlsx?dl=0
Client B: https://www.dropbox.com/s/6k3sfdu56j1uurp/Client B.xlsx?dl=0
Summary: https://www.dropbox.com/s/3lxeum7mvf7bpd0/Summary Macro.xlsx?dl=0


If anyone could help me, it would be much appreciated!!!!!


Thanks
Ryan

 

[ryansm05]

Legend! Thanks Dante

 

[DanteAmor]

Legend! Thanks Dante

Again with pleasure. Thanks for the feedback