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