Printable sheets using multiple lists

[obiwanvaldez]

I am making several schedules that have various assignments in a church setting. For example, one sheet could be dealing with Category A, and has different assignments under that category, i.e. - Assignment A, B, C. I have 3 (although it could be more later) different schedules. I have a master list that lists people who will fill these assignments. I will rotate people in and out of their qualified assignments using names from the master list. Since each person would need a copy of what their assignments are and there would be 3 lists per person, I am trying to autofill a separate sheet with an individuals actual assignments pulled from the 3 Category lists and rolled into 1 sheet. This will put everything in chronological order and cut down on the need for 3 sheets per person. My question is this - is that possible and if so how would I do it. I am not very good with IF and IS functions and I'm pretty sure these would be needed. I really don't know the dynamics of setting those formulas up, but would like to. It seems everytime I try to create one I get an error and don't really knOw why. I appreciate everyone's help on this! Thanks!