I have a few sheets where users need to append, or sometimes update,
regularly.
I want to have summary sheets which comprise of all data of all sheets which
automatically updates all the sheets.
For example, if someone enters new record at sheet2, then it should reflects
at the summary sheet. Similarly for update which I also expect to reflect on
summary sheet.

I think this thing is quite common in many environment, however, I can't
figure out how to achieve this.
Any assistance or idea is greatly appreciated.

Soe,

assume there are 3 sheets (sheet1, sheet2 and sheet3), and type data i
cell A1, B1, C1 in 3 different sheet respectively.
then in summary sheets in cell D1,

type sheet1!A1+sheet2!B1+sheet3!C

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

sorry, i think the phrase "summary sheet" seems misleading.
I don't need sum of records, instead, summary of all records in other
sheets.
Basically, the summary sheet shows every records (rows) from other sheets.
For example, sheet1 has 10 data rows, sheet2 has 5 and sheet3 has 20, then
the summary sheet shoud show all 35 data rows, no need to do any
calculation. Moreover, whoever append or edit in any of other sheet, such
modification should reflect in summary sheet.
any suggestion?

"Soe" <soe@soe> wrote in message
news:#(E-Mail Removed)...
> I have a few sheets where users need to append, or sometimes update,
> regularly.
> I want to have summary sheets which comprise of all data of all sheets
which
> automatically updates all the sheets.
> For example, if someone enters new record at sheet2, then it should
reflects
> at the summary sheet. Similarly for update which I also expect to reflect
on
> summary sheet.
>
> I think this thing is quite common in many environment, however, I can't
> figure out how to achieve this.
> Any assistance or idea is greatly appreciated.
>
>