I have a workbook that is getting very packed when it comes to the worksheets. I do not use all of them all the time, and so I want to hide unused ones at the time based on what i'm working on.

I have a main Index that has a column that has G2:G30 for the range of values to indicate if the sheet will be shown.
I have a range of sheets that have been numbered for referencing below that range from 1,2,3,..... to 26.
I have a Simple VBA solution that will show the single G2 of "Y" to show or to hide otherwise. I have zero clue about how this will look to iterate through these 2 ranges to match things up. They are incremental.

```
Private Sub Worksheet_Change(ByVal Target As Range)
    If [G2] = "Y" Then
        Sheets("1").Visible = True
    Else
        Sheets("1").Visible = False
    End If
End Sub

```

I really need this to iterate through the range to indicate to the sheets in the worksheet.