Combining different sheets with automatic add in?
 

I am currently working on a very big file to help for the forecasting for a
group of companies.(total 245 sheets)

There are 4 companies and Each company has a seperate list of accounts with
balances under the same group headings and with the same colums but with
different account numbers (which are alfanumeric).

What I want to do produce is on a new sheet a seperate list keeping the same
format but under each heading grouping each companies accounts and adjacent
data. Also if a new account is added to one of the seperate sheets have this
automatically added to the consolidated one.

Hope you can help

--
Thanks,
TKA