I have been tasked with creating a single sheet that shows details from multiple (same exact format for each of these separate files) sheets. Its like like a sales managers overview of all of his salesmen.
I know how to just grab the info from the sheets so thats not the issue. The issue is that when you open each of these files you need to click (run a macro to update them).
So i don't know how does one open a sheet- run the macro within THAT sheet- save THAT sheet and then grab some data.... then move on to the next one.. and so on.
I just don't know really where to start here.