How to search by worksheet name in Excel?

This method will introduce a VBA macro to search worksheet in active workbook easily.

1. Press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and then paste following VBA code into the new opening Module window.

VBA: Search by worksheet name

Sub SearchSheetName()
Dim xName As String
Dim xFound As Boolean
xName = InputBox("Enter sheet name to find in workbook:", "Sheet search")
If xName = "" Then Exit Sub
On Error Resume Next
ActiveWorkbook.Sheets(xName).Select
xFound = (Err = 0)
On Error GoTo 0
If xFound Then
MsgBox "Sheet '" & xName & "' has been found and selected!"
Else
MsgBox "The sheet '" & xName & "' could not be found in this workbook!"
End If
End Sub

3. Press the F5 key or click the Run button to run this VBA.

4. A Sheet search dialog box comes out, please type the worksheet name that you will search, and click the OK button. See screenshot:

Another dialog box will come out and tell whether the worksheet has been found or not. Just close it.

Note: This VBA requires exactly matched worksheet name. Only you enter the exactly full worksheet name, you can find out this worksheet with this VBA.

If you have Kutools for Excel installed, you can easily search worksheets by sheet name on the Navigation Pane. Please do as follows:

1. By default the Navigation Pane is opening. If closed, please click Kutools > Navigation Pane to display the navigation pane, and then click  (Workbook & sheet) at far left side of Navigation Pane.

2. Go ahead to check the Filter checkbox in the Navigation Pane, and type the specified keywords into following box. Now all worksheets whose names contain the specified keywords will be found out and listed in the below box. See screenshot:

Note: Clicking the search results will jump and open the corresponding worksheet at once.

Create hyperlink in a cell to another sheet in the same workbook