Move a line to a new sheet/tab once a particular cell says keyword. Do i need macros?

I have several fields on the 'OPEN' tab. Each MUST be populated, and the S column has a dropdown box saying Complete, which must say this before moving the whole row to the 'CLOSED' tab.

Similiarly, if someone wants to reopen the case, there are several other options apart from Closed, ie open, quarantine etc, and if the status is reopened in any way and it doesnt say the word closed, i want it to move back to the top row of the 'OPEN' tab sheet...

I want the line to move if the dropdown at the end of the sheet (COLUMN S) says complete, and if this changes, it goes back to the first sheet?

Can someone please tell me what to do?