I am trying to figure out how to transfer one column on one sheet to another
sheet based on the value of another cell. I have to track work orders and the
ones that are still being worked on over a period of a few days and I need
them to be transferred to another sheet for the next day, For example:

I have 5 sheets based on the work week, If a work order has a status of
"Open" in a cell I want to automatically transfer the column with that status
to the next day (sheet)

any help would be appreciated