moving row to new sheet when conditions are met

I had a similar thread and that issue was solved quickly. so hopefully this an too.

I have columns:

(Issue#) (Complaint) (Bid #) (Po#) ( Dept) (Contact) (Vendor) (Received)

(Resolved) (Completed)

I need it when i input yes under completed, it moves that whole a sheet labeled with the corresponding Dept. So if under Dept it said "water" and i marked it yes for completed, it would move that row to a sheet labeled.

If you could give me the code to do that, maybe i can figure out how to add the other dept names i deal with. Thanks in advance.

this is for excel 2007