Cross Page Formulas

Copper Contributor

How do I get a total from various worksheets to add up in one worksheet?

For example if I have a file with 5 worksheets and totals in various columns in worksheet 1, 2 3 & 4, how do I get all those totals to add up automatically in the last worksheet ?

1 Reply
=SUM(Sheet1! A14,Sheet2! B17)