Referring to data on other sheets

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.

Perhaps Changing the title to "Refering to data on other sheets" may appease the moderators!

As soon as you change the title I will post the solution for you, I have modified your sheet to do what you require!

Hope this helps!

edit the button macro and change it from

Please Login or Register  to view this content.

Please Login or Register  to view this content.

this will also work if you select more than one item to unselect!

Here is the updated sheet, I think this is more what you asked for after re-reading the question!