how to compile updates automatically in a single sheet

[Soe]

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.

 

[raymondsum]

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

 

[Soe Nandar]

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?