Alternative to a Hyperlink

Hi,

I was hoping to possibly use a hyperlink type function for my use case so it is disappointing that SS doesn't have this capability.

Does anyone have any suggestions on how to accomplish the following:

I am building a set of ISO27001 risk assessment sheets and I have a main sheet where there are different threat names listed. I have another glossary sheet that shows the same threat name and an associated description and examples. What I wanted to do was set up a mechanism where clicking on a name in the first sheet opens the second glossary sheet and highlights the row (or somehow displays the description and example from the glossary sheet). I thought that perhaps using an index to find the matching threat name in the glossary sheet would then allow me to identify the row and then I'd have a sheet name and row to somehow hyperlink from the first sheet to the correct row in the glossary sheet.

Regards,

Graham