Search code examples
excelexcel-tables

A table's column of same cell of different spreadsheets

I have different spreadsheets (on the following photo, from 1 to 25); They have the same layout ( Photo here ).

I want to create a table with the E7 cell of each spreadsheet (A table of every "Total").

I tried this by extanding the formula...sounds good, doesn't work.

Solution

  • Put this in the first cell:

    =INDIRECT("'" & ROW(1:1) & "'!E7")

    And copy down.