How to filter information between worksheets?

[Smurrf]

Okay, here's the situation. I'm creating a budget/work order database for my company. Attached is what I have currently designed, with examples of various orders in various stages of completion.

The goal is to have the information on the Master worksheet get automatically filtered to the other worksheets based upon which department each order comes from. This information is then used to tally individual department budgets, which get fed back on to the main page so the Supply officer doesn't have to tab through the rest of the worksheets. Ideally, once the formulas are all entered, no manual data entry would get made except on the Master page.

I realize it's sort of a cumbersome way to do things, and I realize that various other ways of formatting would work better...AutoFilter would work well, and other functions would also work. The problem is that I'm not the one doing the data entry, and I need to make this as simple as possible to use. I already plan to protect all slaved worksheets, and any cells with formulas in them on the main page.

Bottom line, is there any way to automatically have Excel search for a row, by the department modifier in Master!A, and copy that row over to the relevant worksheet?

Edit: Reason for having multiple worksheets by department isn't so much for the budget (that's just a nice bennie) as it is for ease of seeing order status for a single department just by tabbing over. (Yes, this is really what I've been tasked with.)