Link Multiple Spreed Sheets to one Destination Spread Sheet

[Malcolm torishi]

Hi everyone hope you can help.
I have a master spread sheet that is copied into different files that gets stored in say in G drive. So this master spread sheet over time can be copied and stored up to 200 times. Thus 200 copies with different names stored in 200 files under G drive. Eg master1 in one file, master2 in another file and so on. What I am trying to do is to take certain data from certain cells in each of the master1 , 2 files etc and store them automatically into a destination file also saved in G drive, can it me done. If you can help thank you in advance

 

[ravishankar]

you can suitably modify the codes in https://www.mrexcel.com/forum/excel...ltiple-workbooks-many-variables-involved.html
ravishankar

 

[Malcolm torishi]

Thank you so much for getting back to me , I have a had a look at your reply and it helps me so much. Thank you agian