I apologize in advance for any frustration, I'm new to macros and am looking for any guidance I can get.

I'd like to have code in a "master" spread sheet that copies sheets titled "Results - Graphs" and "Results - Tables" from a number of xls files in a directory to this "master" workbook. Below is what I have so far from combining help from recording macro.

Please Login or Register  to view this content.
If possible I'd like to modify this macro so that it loops through all elsm files in this designated directory and copies the two sheets from all files (approx 60), to my "master" xlsm called "Data_Colect". As an added bonus if the code is relatively quick it would be a great help, what I have so far is kind of slow and i don't look foward to running it when it will call on 60 files. From what I have seen I see that this could be done with a for statement for a loop, both of which I am not very familiar with and have failed and writing anything that worked.

Thank you in advance for your help.