Is there any formula or function which can be helpful to simultenously update N no of works sheets in the file while working in the current sheet :

I have 10 worksheets in a file- Region wise Debtors Ageing in Report, along with a Master worksheet which shows consolidation figures of all the Region datas.

Every week I have to submit Billwise Debtors Ageing Report both Region wise for 10 Regions along with the consolidated list in the same format plus a compact summary Report.
The problem I am facing is that, every time I receive collections or if any Invoice is raised to a party, I individually have to Append/Delete/Edit in the respective region data in the respective sheets, and simultenously updating in the Master sheet. This process consumes time and irritating.

I want some Excel Formula that when I use in the individulal sheets will automatically let the master sheet update itself on Addition/Deletion or Edit or vice versa.

Can somebody suggest

Thanks in Advance.....