Referring to data on other sheets

[aquinlan]

Hi,
I coach a junior rugby team and am trying to create this.A4 to D18 i have player names.I would like to use dropdowns which i finally learned about in f5 to f19 to make a team selection.When i press make selection button.I am hoping player names in columnf will go to sheet2 columnD.But the players matching cells on sheet1 will turn blue from a4 to d18 so that means 15 names in that row will be blue in colour.Anyway this will be a preTeam so if i decide to make changes on sheet2 i can press the make changes button and it will kick me back to sheet1 and the names will be back in f5 to f19.so if i pick a name in this range (f5:f19) then press unselect button that player is unselected from list and his name turns from blue in a4 to d18 to normal.Hopefully this is possible cause it would make my job a lot easier.Thank you alot.