Dynamic Hyperlink

Hi,

I get a row reference found from a Index,Match formulae. It tells me where to start over writing some data from.
I want a hyperlink to click on which takes me to the row given by that Index,Match formulae.

So cell Y8 shows row 12345 (by looking up a date from an Index,Match formulae),
I want to make a hyperlink (or button) to take me to a different worksheet within the same workbook at the row shown in Y8 when i click on it.

Currently the hyperlink formulae im using =HYPERLINK("#Y8", "Link To Row in the Above") only takes me to the cell Y8 and doesnt read the output from the formulae in that cell.

I hope that makes sense.

TIA

read here
maybe it will help.

Worked a charm

Thanks so much!