Automatically Move Rows To Another Sheet/Move them back

Trying to find a solution for my specific problem searching on the web, I found many interesting solutions for cut and paste rows from one sheet to another, but I need the rows back to the original sheet when the project is completed:

I have a list of projects in one sheet named MASTER and want to move the specific rows to the sheet OPEN (when a project is still open, it means in progress). When a project is completed, this project (specific entire row) must move back to MASTER sheet. I am not an expert at all in excel and macros, VBA, programming in general... and the most straight forward and simple solution would be the best.

Could be something like when the last column is checked, it would move the open project (the row) from sheet MASTER to sheet OPEN (then I would need to learn how to insert the check box...) and when unchecked the row would go back to sheet MASTER OR a regular last column when you enter the word "OPEN" it would move the open project (the row) from sheet MASTER to sheet OPEN automatically and when you enter completed or whatever the row would go back to sheet MASTER. Or maybe someone could come up with a much better solution.

Thank you very much in advance for any help,

Fer

Originally Posted by popipipo

Why not just one sheet?
With one column "STATUS"
Filter this column on 'OPEN' or 'CLOSED'

I understand your point. I already did that (filter) but still... I'm using a filter but I would like to have a separate sheet. Moving a row of a project in progress from the sheet named MASTER to the sheet named OPEN and when the project is complete I want it to move back to the sheet named MASTER.