Need to link Excel sprdshts w/ AutoFill

I have a Employee Call-Off Log on “Sheet1” and the employee list on “Sheet2”. The employee list includes EmployeeID(Column A), LastName(Column B) and FirstName (Column C).
I would like to be able to type the 4-digit EmployeeID # on the Log, and have the Last & First names autofill in the adjacent cells.
Can someone help? StevenFwx@Yahoo.com

From: stevenfwx@yahoo.com Date: 8/8/02