If a cell has a text, how to move the cell associated to it to a new location (T&F Coach)

Good morning,   I am a track and field coach, and I am trying to create an all-in one spreadsheet that will save me time when making rosters.   I have attached a fake roster where I have a list o...