trying to populate the player column....

granted on the attached form its already populated but.....

what i am trying to do is populate the player column on the overall leaderboard and venue sheets from columb b on each day sheet as well as cells f4:f28 on each dated sheet.
what would be the way do tell it to populate this column?

for convenience sake (i could always use the delete duplicate values function after the fact) is there a means to programmaticly make sure the values are unique while it populates?

thank you