Need excel macro to feed data from on sp

I need an Excel macro that when a user inputs an employee number on the first spreadsheet it will reference a second spreadsheet, lookup the employee number, get the employee name and copy it to the correct field on the first spreadsheet.