Vlookup, Hlookup, pivot table help

[bbor55]

I am attemping to grab information fromt he pivot tables on "TaskHours" and "Task Dollars" tabs. I was previously using a single pivot table for each task - 32410011 and 32410012 would each have their own pivot tables, 1 for hours, one for dollars, but with a massive amounts of tasks the number of different tasks is becoming unworkable.

Using one pivot table for hours, and one pivot table for dollars I want the "Spending" tab to read:

1 Hour and 100 Dollars for employee 1111, Task 32410011, for January 2010, 3 Hours and 300 dollars, Task 32410011 for February 2010.

3 Hours 300 Dollars for employee 1111, Task 32410012, for January 2010, 1 Hour 100 dollars, Task 32410012 for February 2010.

Hopefully this makes sense.