I believe your situation requires a
database. I prefer using Access for such a task, and then using Excel as
a reporting tool.

Within Access; I would build an Employee table, then the data table for
all the positions and other information. Use ID fields for each table,
and link the employee ID to each position  held. You can build user forms
to enter the data, and export the information  via VBA to Excel.

The reason I suggest a database tool, such as Access, is once you create
your recordsets, all the queries you require, as per your message, are
easy to create.