Excel Dropdwon dependent worksheet

[Saikat Dasgupta]

 I want to create a dynamic dropdown based worksheet where in main sheet, when i update the data, it will automatically update in the hidden sheet and using drop down menu i can see and update the data month wise .

Sub copy()

     Workbooks("LEAVE_Attendence RECORD.xlsb").Activate
     Workbooks("LEAVE_Attendence RECORD.xlsb").Sheets("Attendance Tracker").Activate
    
       If Range("D1").Value = "January" Then
            Range("C4:AG59").Select
            Selection.copy
            Sheets("January").Select
            Range("C2").Activate
            Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
        ElseIf Range("D1").Value = "February" Then
            Range("C4:AG59").Select
            Selection.copy
            Sheets("February").Activate
            Range("C2").Activate
            Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
        End If
End Sub