Vlookup 24+ workbook & sheets. Please Help!

[kwanyau30]

I got a lot of (From A to Z) worksheet needed to vlookup form another sheets.
I have 24+ sheets and my formula is

=IFERROR(VLOOKUP(B$4,'C:\Users\Project\Gen001\[qry(a)FB.XLSX]qry(a)FB'!$A:$D,4,0),"")

So, I had to 999+times (24 ppl * 2 sheets * 365 days * 2 rows) copy and paste also change that formula to fit the table.
Looking for a easily way to finish this job. VBA also wellcome.


the workbook like this:

	19-Sep	20-Sep	21-Sep	22-Sep	23-Sep	24-Sep	25-Sep
FACEBOOK	=IFERROR(VLOOKUP(B$1,'C:\Users\Project\Gen001\[qry(a)FB.XLSX]qry(a)FB'!$A:$D,4,0),"")	=IFERROR(VLOOKUP(C$1,'C:\Users\Project\Gen001\[qry(a)WS.XLSX]qry(a)WS'!$A:$D,4,0),"")	100
WHASAPP	=IFERROR(VLOOKUP(B$1,'C:\Users\Project\Gen001\[qry(a)WS.XLSX]qry(a)WS'!$A:$D,4,0),"")	=IFERROR(VLOOKUP(C$1,'C:\Users\Project\Gen001\[qry(a)WS.XLSX]qry(a)WS'!$A:$D,4,0),"")

 

[bobby_smith]

Have you considered using power query?
You can put your files in in a single folder, import into one file or any number and use the merge feature which is similar to the vlookup function.

 

[kwanyau30]

Have you considered using power query?
You can put your files in in a single folder, import into one file or any number and use the merge feature which is similar to the vlookup function.

I had entry a list in access already.
so, Do power query can make a calendar like report? like this pic??