Creating lists of names based on value in a column

[Helluvaname]

I'm sure this is easy to those that know, but would appreciate a "simple" way to achieve this please.
I have a list of members of a charity, and each member has volunteered to work on one or more days.
The data looks like this:

I'd like to have the daily tabs of the workbook display the information like this:

A final tab with "unallocated" members, ie those with nothing in the Day(s) column, would also be useful.

The simplest way to achieve this would be appreciated, bearing in mind the Members list data will be added to, or amended, by non-technical people.
Many thanks, Ian

 

[Fluff]

Cross posted Creating Lists of names based on a value in a column

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

 

[Helluvaname]

Thanks, I wasn't aware of the rule, and was trying to help out a charity in a hurry, hence posting elsewhere.
Replies much appreciated on both forums, and will know for the future!

 

[Fluff]

Did you find out why it wasn't working for Tuesday?

 

[Helluvaname]

Did you find out why it wasn't working for Tuesday?

Erm yes and no!
When I came back to it, the next day it all appeared to be working OK, so no idea, but seems to be fine now!

 

[Fluff]

? Nothing beats a reboot.
Glad it's working & thanks for the feedback.