First Post!

I have a workbook with many worksheets, but I'm only concerned with 6 of the sheets for this macro. On the main page of the workbook I have a drop down menu with currently 2 choices (later it will be expanded to more). I have a cell that is a reference cell on that sheet that just shows "1" or "2" based on which choice the user chose.

If the user clicks the first choice the reference cell says "1" and I want a macro that makes "Sheet 1", "Sheet 2", and "Sheet 3" visible while "Sheet 4", "Sheet 5" and "Sheet 6" are hidden. If the user selects choice 2 I want the opposite to happen.

I've tried about 50 different things and none seem to work. I first made subs in a module that were the "Hide_SetA" that hid the first 3 sheets and unhid the others while "hide_setB" that did the opposite. and in the coding on my main page I had a sub that was supposed to run either of those other subs depending if that cell's value was "1" or "2"

more recently I've had coding like this in my main page based on some google searches

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$N$17" And Target.Value = "1" Then
    Sheets("Sheet 1").Visible = xlSheetVisible
    Sheets("Sheet 2").Visible = xlSheetVisible
    Sheets("Sheet 3").Visible = xlSheetVisible
    Sheets("Sheet 4").Visible = xlSheetHidden
    Sheets("Sheet 5").Visible = xlSheetHidden
    Sheets("Sheet 6").Visible = xlSheetHidden
ElseIf Target.Address = "$N$17" And Target.Value = "2" Then
    Sheets("Sheet 1").Visible = xlSheetHidden
    Sheets("Sheet 2").Visible = xlSheetHidden
    Sheets("Sheet 3").Visible = xlSheetHidden
    Sheets("Sheet 4").Visible = xlSheetVisible
    Sheets("Sheet 5").Visible = xlSheetVisible
    Sheets("Sheet 6").Visible = xlSheetVisible
End If
End Sub
Any help would be appreciated as this has become rather frustrating. Thanks!