Auto populate list

[sick stigma]

In the attached workbook, is it possible to auto populate from 'Time Sheets'!columns C,D and E to 'Dashboard'! B6:B100, E6:E100, H6:H100 a list of all names that fall within 'Dashboard'! "week ending" criteria?
Thanks for any and all help!
Sick

[AB33]

What are the condition for filling the rows? You have Jack Roberts in time sheet, so on what base do you copy that cell to sheet dashboard? Or you just want to fill in the empty cells in sheet dashboard.

[sick stigma]

Typically 'Timesheets" will have 30+ names listed multiple times within a given "week ending". I'm hoping to populate 'Dashboard" with each name, once only, within "weekending". Does that clarify?
Sick

[AB33]

Sick,
Is it possible that you have many names listed in time sheet. For e.g. you have Jack Roberts in ,Sig, x etc. So, if a name appears more than once, which name do you pick up, or it just a single name in each cell?