Okay. I learned a thing or two but still not working for me.

Sheet 1 looks like this


Monday Tuesday Wednesday Etc...

John Smith off 4am 4am
Katie Jones 4am 4am 4am
Dawn Moran 4am 4am off

etc....


I would like sheet 2 (renamed "Monday") to list the names with "4am" under
the column Monday. And not list the names with "off" under the Monday column.


So "Monday" sheet should look someting like

Schedule

Katie Jones
Dawn Moran
etc...