Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Integer
For i = 2 To Sheet4.Range("b65536").End(xlUp).Row
If Target.Value = Sheet4.Range("b" & i) Then
Target.Offset(0, 1).Value = Sheet4.Range("c" & i)
Target.Offset(0, 2).Value = Sheet4.Range("d" & i)
Target.Offset(0, 3).Value = Sheet4.Range("e" & i)
End If
Next
End Sub