I am building a dashboard where difference sections reference multiple pivot tables. I enter the date for the dashboard in a cell (A8) and use that cell in the GetPivotData function (H1) to pull data for a specific month from the pivot table. Now I would like to be able to click a hyperlink in the same cell that has the GetPivotData formula (H1) and go to that part of the pivot table. Maybe I am missing an easier way to do this, but I have had difficulty creating a hyperlink that looks to another field for part of the string.  For example, I will enter 7/31/13 in cell A8.  I put A8 in the GetPivotData string so that cell H1 in my dashboard shows pivot table data for 7/31/13.  If I change cell A8 to 6/30/13, then the data in H1 in the dashboard automatically shows pivot table data for 6/30/13.  I would like the hyperlink in H1 to automatically go to the correct cell in the pivot table based on the date entered in cell A8.  Thanks for your help.