Simultaneous updating worksheets

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.....

Post an exemple of your worksheet if you'd like a resonse...
Drag companiy names over with 1-### if you want confidienciality...

[QUOTE=SUJITPADHI;2512683]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.....


Thanks once again... U Iam attaching a file

I'll go with a simlpe start...

Try having your master file being a reflection of your Region wise sheets.
Whenever you enter a new debtor in your regional file, insert a line above the last entry.
Do the same for the master file. Drag your formula from the row above to the one you've inserted...

You have to add the WH1, WH2 and such, but it's a start, until a real Excel head comes and solves you're problem

btw, in the attachment, I've started doing that at the bottom of your master sheet with the row "someguy".