One way would be to have the data copied from Sheet1 whenever Sheet2 is activated
Option Explicit
'in destination sheet code module
Private Sub Worksheet_Activate()
Application.ScreenUpdating = False
Application.EnableEvents = False
'sheet1 is the source, sheet2 is the destination
Worksheets("Sheet1").Range("B2:B13").Copy Worksheets("Sheet2").Range("B2:B13")
Worksheets("Sheet1").Range("D2:D13").Copy Worksheets("Sheet2").Range("D2:D13")
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub