Using LOOKUP on Pivot Table

The Workbook "Subbies Labour" has a Pivot table with Job Numbers and values against those job number and the Workbook "Job Costs Summary" has a table with Columns with Job Numbers. Is there a formula to read the results on the Pivot Table (Subbies Labour) and put against the appropriate column and row (Job Costs Summary) using the Job Number as a "LOOKUP"?