If you delete an employee from the list you will loose all your work history
for that employee if you are using formula to do your work.
One solution would be to convert formulas to values up to the current date
and then you can modify the lookup table and the data validation list without
You VLOOKUP formulas can look at ranges which are not completely filled -
that means you can leave extra rows for new data.
You can also use dynamic range names to adjust references based on how much
data is in an area of the spreadsheet.
Alternatively, you could run the whole thing via vba but that might be a
major programming job.
If this helps, please click the Yes button