Match Index between Worbooks

[kharding15]

I have tried many ways to do a match index formula in a Summary workbook to read multiple Job workbooks and to make this automatically.Though, the Concatenate formula cannot be done in a match index formula and I cannot use Indirect as there are going be too many Job workbooks to have them open at once. Can someone please help me to set this up as a VBA code in a Command Button.

Here is the code I have in the Summary Workbook, which I will need it in the Job Workbook's button:

=IF('[Example_Job Workbook.xlsx]Master List & Hours'!$A$553=$C$52,INDEX('[Example_Job Workbook.xlsx]Master List & Hours'!$C$554:$UU$577,MATCH($D52,'[Example_Job Workbook.xlsx]Master List & Hours'!$B$554:$B$577,0),MATCH(E$2, '[Example_Job Workbook.xlsx]Master List & Hours'!$C$553:$UU$553,0)),"")

My goal is to have a range of employee's hours per job dumped in one Summary Workbook from multiple Job workbooks. It may need a loop as there will be 1 job with 24 employees (aka 24 rows) and about 3 years worth of dates in the Summary Workbook. Basically if a cell equals to this job number, then match the dates and employee's initials and then dump the hours in the appropriate area.

Attached are the 2 workbooks, Example_Summary (the data dumped workbook) and Example_Job Workbook (the title will change to the job's number and "_Document Schedule" at the end, but these are just examples).

I have a VBA code to open the Summary workbook so this shouldn't be a problem. I just need the job's hours to be dumped into the summary's workbook:

Dim Inputpath As String

Inputpath = "J:\Document Schedules and All Jobs Reports\"

Set WB2 = Workbooks.Open(Inputpath & "All Jobs Documentation List.xlsm")

Please help!
Thank you!!!
Kirsten