Forgive the intrusion...not sure if Mr. Poulsom is still on line.
To answer your question, one way is to use a workbook level event to call a standard VBA macro that is triggered from selecting an option (in your case a sheet tab name) off the pop-up command bar. Thanks to Hans Herber for the basic direction of the following code, which I modified slightly to do what you want. You can find this and ~1600 other interesting examples on the CD being advertised for sale through this site.
The order of sheets listed on the pop-up menu will depend on their index number (the order their tabs appear in your workbook).
In a standard VBA module, insert this:
Sub GoToSheet()
On Error Resume Next
Worksheets(Application.Caller(1)).Select
CommandBars("Register").Delete
End Sub
'''''''''''''''''''''''''''''''''''''''''
In the workbook module, insert this:
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
Dim cReg As CommandBar
Dim cbb As CommandBarButton
Dim ws As Worksheet
On Error Resume Next
Application.CommandBars("Register").Delete
On Error GoTo 0
Set cReg = Application.CommandBars.Add("Register", msoBarPopup)
For Each ws In ThisWorkbook.Worksheets
Set cbb = cReg.Controls.Add
cbb.Caption = ws.Name
cbb.Style = msoButtonCaption
cbb.OnAction = "GoToSheet"
Next ws
cReg.ShowPopup
End Sub
'''''''''''''''''''''''''''''''''''''''''
Now, right click on any cell in any sheet to get a list of sheets in the workbook that you can select and go to.
Is this what you want?