I'm sure there are several ways to do this,
but I've never done the hyperlink  to a hidden  sheet.
What I usually do is use a selectionchange event in the
Index sheet. test to see if the selection is one of the specific cells (or
value, or...) ,
then use a macro to unhide the sheet  and select it.
You can then use a deactivate event (or the activate event for the index  sheet)
to hide the other sheet.
need help with this?