Software

Investigate HLookup() and VLookup() functions. You can have a lookup table with numbers and names on another sheet, and use this function to return the name that matches the number. The number and the employee name will be in different columns, but does this really matter?

I am going to assume the timesheet for each employee is a seperate sheet in the workbook.

You could set up a list of employees with a hyperlink that takes you directly to that employee's sheet.

This link reference will work if all the time sheets are on the same sheet as well.

If your familiar with VBA you could make a front end sheet that has the input box for the employee record and then have the VBA code search for the correct location the sheet for that person.