How to pre-select a list item based on a cell value from another worksheet using VBA

Hello,

I have identical dropdown lists on 2 different worksheets. I would like to have the selected value from the 1 worksheet to be pre-selected on the other worksheet upon moving to that worksheet.

This is the VBA code i have on the worksheets right now:

Private Sub Worksheet_Activate()
If Range("C6").Value2 <> "WEEK" Then
Application.EnableEvents = False
Range("C6").Value2 = "WEEK"
Application.EnableEvents = True
End If
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Not Intersect(Target, Range("C6")) Is Nothing Then
Application.ScreenUpdating = False
Sheets(Range("AB13").Value).Select
Application.ScreenUpdating = True
End If
End Sub

Ideally when they change the 'WEEK' dropdown list item to either 'MTD', 'QTD' or 'YTD' (this switches the worksheet to the 'MTD/QTD/YTD' worksheet) one of the actions is to carry over the selected District or Branch from the applicable dropdown list from the 'WEEK' worksheet to the duplicate dropdown list in the 'MTD/QTD/YTD' worksheet.

Hopefully you can envision this and I haven't confused you.

I figured it out. I just needed to update "WEEK" to Worksheets("Worksheet Name").Range("Cell Reference from dropdown you want pre-filled").