|If you don't mind blank cells in your weekly sheets, you could use something as simple as an IF formula:|
Drag this across the seven cells under the dates on your Week Sheet and then down for as many rows as you have names. The names will show in the same cell location as the times show in the Month Sheet.
Obviously, the B2 would be changed to match the cell under the first day of each week.
If you are looking for something "neater", like all the names listed in contiguous cells under a date, then a macro could that fairly easily. Come on back if you want to see the code that would do that.