Google Spreadsheet

I use a Google spreadsheet to keep track of my program's budget and would like to create a system in which rows are automatically duplicated onto seven other spreadsheets, depending on the code in each row. The goal is to provide staff access to budget information related to their operations without providing details on the entire budget. CURRENT SPREADSHEET The current spreadsheet has two tabs: - Tab 1: Budget The "Budget" tab has the budget line description, the budgeted amount, and the actual amount spent (pulled from tab 2). - Tab 2: Register. The "Register" tab has the date, description, budget line, and amount. MODIFICATIONS REQUESTED 1. If a row on Tab 2 of the main spreadsheet has a budget line that is assigned to a specific person, that row is duplicated onto Tab 2 of a secondary spreadsheet that is assigned to that specific person. There will be seven secondary spreadseets in total. The total number of spreadsheets may change in future years. 2. If a row is changed on Tab 2 of the main spreadsheet, it is changed on Tab 2 of the secondary spreadsheet.