Moving rows from one sheet to another based on a particular cell v
 

Here's what i am trying to do -

Create a status report of multiple worksheets. The first sheet will include
all items in an "open Status" - Status column. I would like to have seperate
reports for deferred, closed and pending.

When I change a status on the first sheet to closed. Is it possible to have
the entire row moved to the closed report worksheet.

I am not great at this so if this is possible - i'll need some step by step
help.