HI

I have a spread sheet that has several sheets containing data specific to each office. I have a Reports sheet that summerises the data and then a summary sheet. The summary will change depending on the date chosen and office selected. What I want to do is create a hyperlink on the Summary sheet that staff can click on to view their office YTD results. I have a formala in Reports A2 that lists the office selected, so is there a way in the summary sheet to reference back to the result in Reports A2 and select the relevant sheet from that result?