Consolidated results across worksheets with Row ans Column remain same

Perhaps this formula; it adds the values in B2 across sheet1 to sheet3

Formula:

=SUM(Sheet1:Sheet3!B2)

Thanks