Adding rows automatically in two separate worksheets

Hi,

Going straight to the point, this is the situaton:
I want to make a worksheet that combines few different worksheet's into one (added an example). However, I cannot think of a way to make the main worksheet (Full Balance Sheet in example) to be feeded information which is added later, in assets, liabs or equity worksheets.

As Assets, Liabilities and Equity worksheet's will be modified constantly, I would like that this automatically would feed into Full Balance Sheet. Rows can be added in between, for ex. between ''Land'' and ''Buildings'', and in the end, for example after "Other tangable assets". Every row will probably have formula in it, so not losing it is also important.

Now that I look at it, I should have posted this thread in Excel Programming / VBA / Macros section, as I cannot find an easy way to come arround this problem with simple formulas.

Thank you in advance for your assistance.

Regards,
drakaz