Formula to combine 2 spread sheets into one

[dramon]

Is it possible to combine sheet 1 and sheet 2 into sheet 3? If it is what's
the formula?

 

[Farhad]

Or you can put the formula below in the sheet 3 cell A1:

=SUM('sheet1:sheet2'!A1)

Thanks