Referencing a cell from another worksheet in VBA

[a-man]

Hi,

I have a drop down list in sheet 'Reinforcement' located in cell G4. When this cell selection changes, VBA code hides/unhides certain rows.

In sheet 'summary', i would like to reference the drop down list in 'Reinforcement' in cell G4 to hide/unhide rows. Below is the successful code used when hiding/unhiding rows in 'Reinforcement':

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("G4")) Is Nothing Then Exit Sub

Application.EnableEvents = False 'to prevent endless loop
Sheets("1. Reinforcement Calculation").Unprotect Password:="xxxxxxx"
Select Case [g4].Value
  Case "Standard Calculation"
    Rows("128:138").EntireRow.Hidden = True
    Rows("101:127").EntireRow.Hidden = False
  Case "Select"
    Rows("101:127").EntireRow.Hidden = False
  Case "Fancy Tap"
    Rows("104:127").EntireRow.Hidden = True
    Rows("128:138").EntireRow.Hidden = False
End Select
Sheets("1. Reinforcement Calculation").Protect Password:="xxxxxxx"

Application.EnableEvents = True
End Sub

How do i change this code so that it refers to G4 in the 'Reinforcement' sheet when the code is running in the 'summary' sheet?