Generate Roster based on working days

Good Afternoon Everyone!

My goal is simple, but being an excel noob is making this extremely difficult. I've been doing some research and have been trying to figure out how to get this to work, however I believe I'm going to need to use more than vlookup to accomplish my task.

I'm trying to create a spreadsheet that for a role call for each day. I want each tab to populate based on employees working schedules since they can change somewhat often. I'm trying to use a master tab that has all employee info (Name, What days they work, and phone number). I'll posta dummy excel sheet below to provide some clairty. If someone could point me in the right direction, I would be extremely grateful. I've been doing this manually for the past few weeks and I want to learn to be proficient in excel in order to make my life easier. Appreciate any guidance you may be able to provide!

You are using 365 Pro - I know with O365 you get the new Dynamic Array Formulas so I'm assuming you get them w/ Pro as well.

In any sheet, in cell A2 you can enter:
=FILTER('Main Roster'!$A$2:$A$6,ISNUMBER(SEARCH(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255),'Main Roster'!$B$2:$B$6)))

In Cell D2 enter:
=FILTER('Main Roster'!$C$2:$C$6,ISNUMBER(SEARCH(MID(CELL("filename",D1),FIND("]",CELL("filename",D1))+1,255),'Main Roster'!$B$2:$B$6)))

GeoffW283 Thanks so much for the help. Your formula solution was exactly what I was looking for. I have 0 experience with VBA, but I was able to figure out how the formula worked and tailored it to my specific needs. I appreciate your help sir!

Glad I could help. Thanks for the feedback and reputation points. I'll take the thanks but I'm curious though why you didn't go with Greg's solution in post #5. I don't have Office 365 but O-365 features like "filter()" can drastically simplify some problems (like this one) as Greg showed.