Copy Rows from Master Sheet to Child Sheets Base on Values

[Traquair]

I am trying to set up a sheet that will automatically copy rows to another sheet within the same workbook based on specific values in one column. I have attached my work in progress in hopes that it will better explain what I am trying to do.

Under the Itemization Tab I am looking at consolidating Branches under different Tabs.

Thanks for any help.

[royUK]

I really cannot see the need to duplicate data to "child" sheets. It's a waste of time when Excel has powerful database tools such as PivotTables available

[Traquair]

Not sure what that is but I do, indeed, have a need for the spreadsheet to be set up that way.