Conditional formula question

Also...another question that goes along with this original one but isn't as complicated...

On the same spreadsheet I have a set of cells that are linked to the rankings list. I'd like to keep the rankings list numbered from 1-32 but when I reorganize them the cells don't follow where the last name was. So, basically is there a way to have cell F1 (for example) to link or reconnect easily to cell the value from A1 if the name in A1 moves down to A3 (for example) as well as B1 which would move along with A1 to B3.

Nevermind about the original post, I actually had an epiphany and came up with a simple method, although a bit of a cheating way, it'll serve the purpose.

If anyone can come up with an easy way to solve the 2nd issue (2nd post I made) that would be very much appreciated.

Doing it as fast as possible...here's a screenshot of it...

basically, the Bears from Z2 I want to follow the cell that says Bears in A6, as well as the rest in the colored section on the right side...When I sort the area on the left so it has the rankings from column E, these cells won't follow the names, but stay at the current cell...

Link to Screenshot

Thanks a lot for the quick reply

Any ideas on what to do for the last post?

Thanks!