Excel Summary page

Afternoon all,

I am trying to create a summary page that will pull the associate_name from each days page and then display them on the summery under the DA name, however i need to ensure that it doesn't duplicate names...

Any help would be fantastic, i have attached a test file for example.

The individual pages have to remain as these will contain the different days of the weeks data.

Thanks.