Copy rows based on cell content

[ashncg]

I have a master sheet with information that I need to have automatically transfer over to the proper sheets based on the content of 2 cells in the row: agent assigned, and status. if the status is "closed" or "4" then I need the row transferred over to the sheet titled "closed production." On top of this, I need some of the information transferred to the proper agent's worksheet based on the agent assigned. I am completely inexperienced in VBA and I have never used a macro for something like this. Please help! I have attached an example workbook. Thanks!