Copying "filtered" data to another sheet

Hi,

I'm not sure if this is the right board to post this on but hopefully someone can assist me.

I have a spreadsheet (Master Database) that I want to use to as a master list of data. This master list will contain certain information about staff training.

However I also want the data to be automatically copied to one of 9 other spreadsheets that are division specific.

So if when entering data on spreadsheet I select Regional Staff as the Division for the first row, I want the data to also appear on the Regional Staff spread sheet. If I was to select Altona as the division, the data to appear on the Altona spreadsheet and so on.

Also if in the status column it says inactive, the information would not be copied to the division specific sheet.

I've attached a copy of the document without staff details.