Assuming your sheets are properly ordered,
you can enter in Shett1!A1:
=SUM(Sheet2:Sheet4!A1)

HTH
--
AP

"paule1982" a écrit dans le message de
...
Hi guys,

Can anyone tell me, how I can add data from lots of different worksheets
and
then total it on another worksheet.

(e.g.
Sheet 2 A1 = 2
Sheet 3 A1 = 3
Sheet 4 A1 = 4)

Need the answer to appear on sheet 1 as which in this case should be 9