Hyperlink using indirect function

Hi there,

I have the below formula which I'm using across several cells. The $A$1, which locates a particular tab from a drop down list, is interchangeable.

The formula below works exactly how I want it to, all i'd like to do is add hyperlinking functionality to it - so when I click on the cell it automatically takes me to the particular tab in question.

=IFERROR(INDIRECT("'" & $A$1 & "'!$CY$18"),"Data Not Measured")

How do I go about doing this?

Thanks

try

=IFERROR(HYPERLINK("#'"&$A$1&"'!$CY$18"),"Data Not Measured")

Thankyou both

you're welcome