If that employee ID will be in B2 then the following macro will do what you need:


Sub UpdateEmployee()
 Dim Found As Range, Look As Range
 Set Look = Sheets(1).Range("B2")
 'Set Look = Cells(ActiveCell.Row, 2) 'Uncomment this if you want to select the row to update
 Set Found = Sheets(2).Columns(2).Find(What:=Look.Text, After:=[B1], LookIn:=xlValues, _
  LookAt:=xlWhole, SearchOrder:=xlColumns, SearchDirection:=xlNext, MatchCase:=False)
 Found.Offset(0, -1) = Look.Offset(0, -1)
 Found.Offset(0, 1) = Look.Offset(0, 1)
 Found.Offset(0, 2) = Look.Offset(0, 2)
End Sub

However, if you want to select a cell someone in the row of the employee to be updated, then uncomment the second Set Look line, and comment out the first.
Do you need any help creating a button or implimenting this? If so, do you want a button on the toolbar or a grey command button on the sheet?