VBA Pull/Vlook up to same range on Dynamic amount of workbooks

[CBG05QB]

Ok so heres the deal,
I have a folder which houses weekly files for the year,
the files are in the exact same format evey week.
The file shows man hours worked on overtime.
I want to pull the same 4 range's from one sheet in each workbook into a summay sheet that calculates my YTD expenses for OT.

I need help in writing a VBA code that targets the folder and tells it to pull "X" range, "Y" range ect... from all the files in the folder, that way it stays dynamic as more files get added. Does anyone have a suggestion for me.

I currently have no code written RE this since I dont know where to start, I am very much a novice in VBA. (I am a quick learning novice though).

Any help yould be much appreciated.

Thanks in advance
Brad

[CBG05QB]

Ok, so I have looked into this issue a bit more, and I found some code that was helpful, but I still cant get it right.

Please Login or Register  to view this content.