How to move an entire row to a new sheet when a status is changed in excel

With 2013, you're going to need a macro to do this. Something to consider is keeping all data in one location in 1 sheet and then using filtering to get desired records. If data sets have the same type of information and the same fields, it's best the data is kept in the same sheet.

You could also use Custom Views to switch quickly between a set of views:

Create, apply, or delete a custom view (microsoft.com)