Put this in B2 of Sheet1, assuming you enter the first employee's name in A2 and that your table of names and numbers is in Sheet2:

=IF(A2="","",VLOOKUP(A2,'Sheet2'!A:B,2,0))

then copy down as far as you need to.

Hope this helps.

Pete