Return mutiple data points from external workbooks

[GCIBrian]

I have a weekly spreadsheet that summarizes work by job and breaks it down by each employee that worked on that job and the hours they worked for the week. The only thing that changes each week is the title of the new spreadsheet ('DetailedCalculatedTime_2015-5-15_Brian' becomes 'DetailedCalculatedTime_2015-5-22_Brian'). I need to pull information by job from the summary into each jobs worksheet. I've attached 2 job worksheets and 1 summary as an example. So far I was able to return the first employee of the first weeks job, but only when summary spreadsheet is filtered to only reveal that particular job.