Returning whole table row if criteria is met in one of multiple columns

So I have a schedule on one worksheet, In Column A I have date, Column B a start time, some more columns in between, then columns E-G have names. I want to return whole rows from this table to another sheet based on whether a name appears anywhere in columns E-G. For example, I want all of Deb's classes to show up in another worksheet regardless of if her name is in Column E or Column F and if we pencil her in for another class on the main worksheet I want the second tab to reflect that change.

Please see attached file


Example.xlsx

Perhaps something like this? Pls find the file attach

regards

Originally Posted by azumi

Perhaps something like this? Pls find the file attach

regards

This works great until more dates get added to the bottom of the master list