I have an employee spreadsheet with multiple sheets. I have several areas where employees can work and can work in several areas.
Sheets
1. Complete list of all employees
2. Area #1
3. Area #2
4. Area #3
The employee lists in the different areas are pulled from the complete list with an If Area 1=X and so on. The problem comes when i delete an employee from the complete list, it gives a #REF! error on the other sheets where the employee is listed. Really any addition or subtraction from the complete list changes the other sheets and they each have to be linked to the correct row in the first sheet.

Any help out there or other thoughts on how to go about this spreadsheet in a different way?

thanks