"Are we saying there is no way of adding any vba to this
cell that unhides the hidden  sheet THEN sends you to the destination ?"

I say "NO, it's not impossible", but think with me: Since VBA will be necessary,
why don't we create a simple code that does ALL the service?? If we can do it,
our users will don't need to worry about hyperlinks... just put the sheetnames
and description. Today I had to create another sheet  like this, see my solution:

'MENU SHEET:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
Dim S As String
Dim N As Integer
S = ActiveCell.Offset(0, -1).Value
For N = 2 To Sheets.Count
Sheets(N).Visible = Not MENU.Range("hideall").Value
Next
Sheets(S).Visible = True
Sheets(S).Select
Err.Clear
End Sub

Well done. This is all.

I am turning this file  available on the net, please find the link below to see
how it works:
http://www.galvao.pro.br/excel/menu_vba_links.xls