I am trying to do something like the following:

Have a Summary WS with companies in the columns:


Balance Sheet Comany 1 Company 2 Company 3...
Cash
Receivable
From Company 1
Company 2
Company 3
PP&E
Liabilities & Equity
Ect..

The companies have their own worksheet and have the same formatting for accounts, IE the same as above.

What I am trying to do is be able to add/delete rows in the summary sheet if I need to add accounts and have the summary as a main reference, so that when changes are made to the summary account they will also be made to the individual companies statements.