To navigate into your excel sheets using Listbox, You need to add a ListBox in a UserForm and copy this two simple procedures in the Userform Code:
Private Sub ListBox1_Click()
Sheets(ListBox1.ListIndex + 1).Activate
Private Sub UserForm_Initialize()
Dim sht As Worksheet
For Each sht In ActiveWorkbook.Worksheets
Once you show the UserForm it will add the names of the sheets in the ListBox, then when you click on one of the sheets name in the ListBox it will activate the corresponding sheet in the WorkBook.