Código hoja 1:
Código:
  
Código hoja 2: 
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 16 And Target.Column = 2 Then
    Hoja4.Range("B16") = Range("B16")
End If
If Target.Row = 17 And Target.Column = 2 Then
    Hoja4.Range("B17") = Range("B17")
End If
If Target.Row = 18 And Target.Column = 2 Then
    Hoja4.Range("B18") = Range("B18")
End If
If Target.Row = 19 And Target.Column = 2 Then
    Hoja4.Range("B19") = Range("B19")
End If
If Target.Row = 16 And Target.Column = 3 Then
    Hoja4.Range("C16") = Range("C16")
End If
If Target.Row = 18 And Target.Column = 3 Then
    Hoja4.Range("C18") = Range("C18")
End If
If Target.Row = 26 And Target.Column = 3 Then
    Hoja4.Range("C26") = Range("C26")
End If
If Target.Row = 27 And Target.Column = 3 Then
    Hoja4.Range("C27") = Range("C27")
End If
End Sub
Código:
  
 Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 16 And Target.Column = 2 Then
    Hoja20.Range("B16") = Range("B16")
End If
If Target.Row = 17 And Target.Column = 2 Then
    Hoja20.Range("B17") = Range("B17")
End If
If Target.Row = 18 And Target.Column = 2 Then
    Hoja20.Range("B18") = Range("B18")
End If
If Target.Row = 19 And Target.Column = 2 Then
    Hoja20.Range("B19") = Range("B19")
End If
If Target.Row = 16 And Target.Column = 3 Then
    Hoja20.Range("C16") = Range("C16")
End If
If Target.Row = 18 And Target.Column = 3 Then
    Hoja20.Range("C18") = Range("C18")
End If
If Target.Row = 26 And Target.Column = 3 Then
    Hoja20.Range("C26") = Range("C26")
End If
If Target.Row = 27 And Target.Column = 3 Then
    Hoja20.Range("C27") = Range("C27")
End If
End Sub
 
