Sort issue Sort Of
 

I have cells A1, B1, C1, D1 and E1 each contains a name. What I need to do
is, if the contents of say cell C1 is deleted the I need the contents of
cells D1 and E1 to move up. It is critical that that the name remain in the
same order (there by precluding a normal sort). So this would have to work
regardless of which cell(s) are cleared.