Selecting one cell from multiple sheets for summary page

Ldiggins 

Additional possibilities and methods are to use Power Query Editor and PivotTable. 

You can also use 3D Reference or Consolidate Command to create a summary table from multiple worksheets.

Here’s how you can use Power Query Editor and PivotTable:

1. Select any cell in your data range.
2. Go to Data > Get & Transform Data > From Table/Range.
3. In the Power Query Editor window, select all columns except column C31.
4. Go to Transform > Unpivot Columns > Unpivot Only Selected Columns.
5. Close and Load the query to a new worksheet.
6. In the new worksheet, go to Insert > PivotTable > OK.
7. In the PivotTable Fields pane, drag Sheet column to Rows area and Value column to Values area.
8. In the PivotTable, right-click Sheet field and select Group > By > OK.
9. In the Grouping dialog box, select By Sheet and click OK.

Additional Link & methods: Excel creating a summary from multiple tabs in a workbook

I hope this helps!