Pivot Table Lookup

Here is the problem:
Three tabs on a worksheet: Tab one "Data" , Tab two "% past due", Tab three "SQM". Yes I know that the users can chose the data they wish to see through the drop down's but it is not in the format that my picky users want.

the pivot table is set up from A:F with table formating intentionally set with merged labels.
Column A is Supplier Code (Many merged cells: Cells a5:a9 is label xyz, A6 Z)
Column B is Supplier Name (Same as above statement)
Column C is Date code (MMMM:YY) So C5:C9 are different dates for supplier xyz
Column D is a Late % for each date
Column E is an on-time% for each date
Column F is grand total

So in Tab 3 the user wants to set up a rolling 6 month history on a selected set of suppliers based on the pivot table information.

Column A is Supplier Code
Column B is supplier name (pulled through Vlookup based on column A)
Column C:D Row 2 (Merged Cells)Is date Calculation (Since this is a 6 month Rolling) today-6
Column C Row 3 Late % (Cell Label for that Month)
Column D Row 3 On-Time% (Cell Label for that Month)

I would like to pull the Late% by date by supplier code over into C4. I have used the following formula =INDEX('% past due'!$A$4:$F$750, MATCH($A$4,'% past due'!$A$4:$A$750,), MATCH(C2,'% past due'!$A$4:$F$4,)) and get N/A

I have used =INDEX('% past due'!$A$4:$F$750, MATCH(C2,'% past due'!$A$4:$F$4,),4) and have received the % Late for the first date matching my C2 value...This does not apply the supplier code.

I know how difficult it is to visualize these tables so I have attached a PDF file to illustrate. To protect my suppliers names I have removed them from the data page and Pivot Table.

Any help is appreaciated.