Good afternoon

I am trying to generate a list of names in a given range of cells on a summary worksheet, that correspond with a range of cells in multiple worksheets (named 1st through 31st). The problem i am having is the names will be entered manually each day followed by the hours worked them rooms cleaned, so the data will not appear in order. i would like the list on the summary sheet to reflect all the names in order, but only once.

My next issue will be continuing the remaining columns to reflect the variance in the persons productivity by cross checking all of the sheets

Productivity1.xlsx