How do I select across worksheets within a file?

I want to select across worksheets and view the accumulating total at the
bottom of the worksheet.