I want to click on a hyperlink on sheet1 and have it open a hyperlink on
sheet2, rather than just going to the cell reference on sheet2.

I can't work out how to do it. Does anyone have any ideas?

Why not include an optional second hyperlink on sheet 1 which goes straight
to the point that the hyperlink on sheet 2 is directed?

Griff