Getting PivotTable data

Hi everyone,

I have an Excel file linked to tables in an Access database.

The 4 tables are each on a separate worksheet. I have a PivotTable for each of these tables too.

I want specific data to be dragged to a separate worksheet, depending on if the date matches a certain cell and the week matches a certain cell.

I have attached a picture to make this more clear.

For example: Cell F4 in the 'Chart' Worksheet should be dragging in the data from the 'Plaining' Worksheet where the date is 13/8/2012 and week is 1233.

Cell A1 gets the week with a function called ISOWEEK. ="Week: "&ISOWEEK(NOW(),1)

Cell F1 shows the day and gets the date. ="Monday"&CHAR(10)&TEXT(FIRSTDAYOFWEEK_LOC(33)+COLUMNS($A:$C)-3,"dd/m/yyyy")