it's better to create a VBA that "looks" into the cell and leaves
you to the hidden sheet (unhiding it before).
I have a sheet here where I created a menu like this. The old guys made a harder
solution, with ComboBox and white/hidden cells... so I tried hyperlinks, but
with hyperlinks I have noticied that my users was not able to update the menu
when needed. So, my solution was made this VBA. Users can create new sheets and
the only work is add a new line on this simple menu.
And about the original solution, I keep only the "hide others" feature, but
changing the "For 2 to XX" to "For 2 to Sheets.Count", thinking on a error-free
solution when the user add more sheets.