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]

How about

Working groups.xlsx
	A	B	C
1	Working Group
2
3	Monday	Time	9.15am
4
5	Leader	Joe Bloggs
6		Mini Minor
7		Frank Stare
8
9
10
11
Monday

Cell Formulas
Range	Formula
C3	C3	=INDEX(Members!$G$4:$G$100,AGGREGATE(15,6,(ROW(Members!$G$4:$G$100)-ROW(Members!$G$4)+1)/(Members!$F$4:$F$100=A5)/(ISNUMBER(SEARCH($A$3,Members!$E$4:$E$100))),1))
B5	B5	=INDEX(Members!$A$4:$A$100,AGGREGATE(15,6,(ROW(Members!$A$4:$A$100)-ROW(Members!$A$4)+1)/(Members!$F$4:$F$100=A5)/(ISNUMBER(SEARCH($A$3,Members!$E$4:$E$100))),1))
B6:B10	B6	=IFERROR(INDEX(Members!$A$4:$A$100,AGGREGATE(15,6,(ROW(Members!$A$4:$A$100)-ROW(Members!$A$4)+1)/(Members!$F$4:$F$100<>$A$5)/(ISNUMBER(SEARCH($A$3,Members!$E$4:$E$100))),ROWS(B$6:B6))),"")

 

[Helluvaname]

Fantastic, that works, thanks very much!
Wish I understood how it worked though!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Helluvaname]

Actually, one more question please!
I've tried copying the tab to get Tuesday (etc), but get #NUM! error in cells C3 and B5.
What do I need to change for each day?

 

[Fluff]

You shouldn't need to change any thing as long as you put the formulae in c3, b5 & b6 down for each sheet.

 

[Helluvaname]

Hmm, OK, I think I must have something slightly different on my actual data file from the "test" file, as you're right it works on the test file.
On the data file I have added two more columns at the start of the sheet (A=First name and B=Surname, and then for example C3=A3&" "&B3 to combine them into the full name (this is so they can sort the list by first or surname).
So in B5 for the leaders name I have:
=INDEX(Members!$C$4:$C$100,AGGREGATE(15,6,(ROW(Members!$C$4:$C$100)-ROW(Members!$C$4)+1)/(Members!$H$4:$H$100=A5)/(ISNUMBER(SEARCH($A$3,Members!$G$4:$G$100))),1))
Which works for Monday but not Tuesday.

I also have the Time displayed in B3 not C3. so in B3 I have:
=INDEX(Members!$I$4:$I$100,AGGREGATE(15,6,(ROW(Members!$I$4:$I$100)-ROW(Members!$I$4)+1)/(Members!$H$4:$H$100=A5)/(ISNUMBER(SEARCH($A$3,Members!$G$4:$G$100))),1))
Which works for Monday, but not Tuesday.

I'm afraid i don't understand the formula enough to know what I need to change to allow copying to a new tab for a new day?

 

[Fluff]

Does A5 on both sheets have the word Leader & A3 has the day of the week?
If so make sure those cells do not have any leading/trailing spaces.

 

[Helluvaname]

Yes, both Monday and Tuesday sheets are as above (and I copied Monday's sheet to make Tuesday)

 

[Fluff]

If it works for Monday, then either there is no data for Tuesday, or the values in A3 & A5 are wrong.