Showing/hiding worksheets basd on cell content

[Nardil]

I have a workbook with a bunch of individual worksheets with specific information, as well as one general worksheet. I'd like to be able to put a name in one cell in the general sheet and have it automatically hide every worksheet but the one that shares a name with the content of that cell. Any help would be greatly appreciated.

 

[JLGWhiz]

Put this code in the sheet code module of the general worksheet. I will use cell A2 in the code but you can change that to the actual cell that you will be using. The line where the cell reference must be changed are noted "Change"

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> "$A$2" Then Exit Sub 'Change
Set sh = Target.Parent
    If Range("A2").Value <> sh.Name Then 'Change
        Sheets(Range("A2").Value).Visible = True 'Change
    End If
    For Each wks In ThisWorkbook.Sheets
        If wks.Name <> sh.Name And wks.Name <> Range("A2").Value Then 'Change
            wks.Visible = False
        End If
    Next
End Sub