Excel sheet

Hello All!
I need some help with my sheet I made.
I want to be able to insert a 1,2, or 3 in the yellow (shift) field and have him automatically go over to his shift numerically listed by his seniority number.
If he changes shifts, say from 1 (Days) to 3 (Mids), all I want to have to do is change the 1 in the yellow cell to a 3 and have his employee number and name move to the Mid shift and
list and arrange automatically by seniority, with no open cells in-between each other.
Attached is Test 1 the chart, and Test 2 what I was wanting it to look like.
Thank You to whoever can help me!

/Users/Randy/Desktop/TEST1.xlsx

/Users/Randy/Desktop/TEST2.xlsx

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)