Corporate Scorecard, Pivot Table Design Question

[OTOTO]

I have three tables. The first table calculates to the second and the second calculates to the third. In order to easily see the information in the third table that goes into the final calculations I would like to create a pivot table so that the component data can be displayed.

My first attempt in doing this is to create a master aggregate table, which contains the data from all three tables, then creating a pivot table from this which looks like my existing third table but with drop downs to show second and first table data. The result is not what I expected. The column headings (Jan-Dec) are not showing as they do in the master table and data sets are getting added up! This is a table which contains varying levels of data, not equal data to be added up!

Any ideas on the best way to achieve the desired result?

 

[OTOTO]

For clarification I have copied the following images to the question. This is the format that I want in the table. In the first image I would like the table to pull numbers in directly from either a table or from the formatted datasheet that I created to make this pivot table. I am not sure how I would build this data element into my database though.... In fact, I am not sure what the correct way to pull this information is into the rows with these fields. Is there a way to enter VLookups into the table?
The second image shows the three data points that go into the "Employee Development & Training" data point. For each of these three data points the Jan-Dec table should fill from either the table or the database that I have created.
For the sub-data points, when I attempt to add the numbers that I have in the datasheet, the table wants to SUM or Count, or Product the numbers. I just want to pull the numbers one for one, not do anything with them for this view. Is there a way to accomplish this?

 

[OTOTO]

Please note that I am using Excel 2007