drop down cells and put the bottom at the top in a new sheet

[dave needs help with excel]

i have a column with names in it and in every new sheet i want the names to
drop down 1 and the bottom 1 to go to the top can anyone help