vlookup on multiple workbooks into 1 main sheet

Hi Everyone,

Sorry for the title I wasn't sure how to word it but here goes I have uploaded only one sheet which I have users in my team completing and they all have individual folders

For example

Adam has a folder and in that is the spreadsheet
Cameron has a folder and in that is the same spreadsheet but different data
and this goes on for 4 teams and about 40 agents


Now here is the question and I'm sorry for babbling but is there an easy way or macro or anything I can make I want a main sheet to be able to go out and collect all the data from all workbooks from the status tab for the 1st and 2nd etc..

Can someone please suggest how I can do this or what I can please do please and I'm kinda needing this for my teams in a few days and I have tried everything I know..

Sorry to bug everyone

Thanks

Ads