shifting cells up in team alignment tab and having corresponding team tabs update as well

I am having problems with removing the contents of a cell and shifting the data up. The team alignment tab has different teams listed on it. When I delete a team member I want the cells in the team alignment tab to shift up and the empty cells to shift down. Currently when I delete the cell and shift up it deletes the cell and that causes an issue with the integrity of the team alignment sheet by deleting the empty cell. Also when I delete the cell and shift up the corresponding team tabs replaces the deleted team members name with, "ref" and it doesn't shift up. Any help would be greatly appreciated as I am a dummy when it comes to excel and haven't taken a course since 2006.

Hi cwbalboa, how exactly are you deleting the cell, and in what worksheet are you referring to; are they all fed from another worksheet; are you deleting via vba?

I go to the team alignment tab and hit right click delete and shift up sells on the corresponding team member I want to delete. The team alignment is like a master tab all the other team tabs pull from. The team alignment tab doesn't pull from anywhere else.