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.