formula to pull pivot data into static report

OK, here's the question: I have a list of data that I need to selectively extract data for a static report. I moved the data into a pivot table, but since the pivot is dynamic, it won't work if there is anything missing from the data, hence the need to like to a static formatted report.

I have a row (1) across the top with company numbers. Down the left (column A) is a row of codes. The formula would look at the company number at the top of the column, then the code on the row (that the formula is on), and return the appropriate value from the pivot table. I am hoping the result will be simple enough that a user can populate the data extract, then simply refresh the pivot and the report will populate.

It seems simple enough, like a nested if/then, but I have been spinning my wheels for a couple hours on it with no luck.

Attached is a sample file.
formula to fix.xls
Thanks

Hi,

The formula to use in cell C2 of report tab is

=sumproudct((data!A2:A84=report!C1)*(data!E2:E84=report!$A2)*(data!$D$2:$D$84))

When u put this formula there it wont give you the desired result as..
in data tab.. if you click on any company or cat code you will find that number eg. 500 appears in formula bar as '500.

Change the format of the data represent in data tab then only this formula will work