For such scenarios, Access is a vastly superior tool to Excel. In Access, you would create one table (a list) of employees, with each record containing the employee’s name and ID number.

When you want to create an employee or client directory in Microsoft Access, the usual Report formats based on forms or single-column lists are usually inadequate.