How to Sum Across Worksheets in Microsoft Excel. Using multiple sheets in the same Excel workbook helps organize data into distinct categories. For example, you might have sales data for each of ...