Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

How to Combine Worksheets Inside an Excel Spreadsheet. There may be times when a business proposal or report you need to write needs data that is kept in two or more separate Excel worksheets.