Pivot Table - Excel 2003

[Longie1985]

Hi,

This is my first post, and taking into consideration this new job I have started it could be one of many!

Question:

I have 2 tabs open, "sheet1" "sheet2" sheet2 is were my pivot data is held and I have implemented my pivot table to show on sheet1, (trying to keep things tidy).

Also on Sheet1 is a summary page, for example the data I have is;

Changes Available
Changes Unread
Changes Read
Changes Read %
% off Target
Prev wk Read %
Prev wk Diff

Now this is what I am stuck on, I basically want to be able to click on "Changes Read" (D10) like a hyperlink if you will and have this open up a set of data I have already within my Pivot (S12) can this be done?

So at the minute the Pivot table is sitting at the side of sheet1 and I want to link a cell outside of the pivot table to a cell on the same sheet within the pivot table...

Thanks

Longie1985