I have a multiple page document that is tracking my departments PTO. There is a single "Department" calendar and then individual calendars. On the Department calendar I need each day to list everyone who requested time off on that day, and skip the people who did not. Right now, I can make it list for one person, but how do I get it to do it for multiple people across many pages in a single cell. Here is what I currently have:

=IF(('employee1'!B8<1),,ʺEmployee1ʺ)

Now I need it somehow continue to say "AND IF(('Employee2!B8<1),,ʺEmployee2ʺ), etc. Is this even possible?

Many thanks!
Jennifer