vba vlookup updates current data's from closed workbook undefined name of workbooks

I WANT VLOOKUP THROUGH CLOSED WORKBOOK WITH WORKSHEET OF "ONSITE" BY VBA

I HAVE ONE MASTER AND MULTIPLE UNNAMED WORKBOOK LIKE(A-Z) IN SHARE POINT FOLDER, TEAM MEMBER UPDATES DATA'S EACH AND INDIVIDUAL FILE IN THAT FOLDER I WANT PULL THE UPDATES TO MASTER THROUGH COLUMN VALUES OF L:L,, I WANT LOOKUP COLUMN (PART DELIVERED TO PUDO, ETA DATE ,STAUS ,REMARKS,To be Closed today ,AGENT ) UNDER THE COLUMN WHAT ARE UPDATES UPDATED I WANT RETRIVE THAT DATA ONLY...

FOR E.G ORDER NO IS 7005345402 IS IN MASTER SHEET THERE SOME UPDATES IN A FILE AGAINST SAME ORDER NO 7005345402 I WANT PULL THAT DATA INTO RANGE OF O:T To be Closed today AGENT .

PLEASE FIND THE ATTACHMENT