Forum Discussion
Summarising the difference of 2 cells from 100 sheets to one sheet
1) I have 100 sheets with exact same format, just different data 2) I need a summary page with 100 rows representing the 100 sheets, column 1 - names of the 100 sheets column 2 - will be the diffe...
In C4 you may use formula
=INDEX(INDIRECT($B4 & "!S10:$S$24"),MATCH(C$3,Sheet2!$Q$10:$Q$24,0)) - INDEX(INDIRECT($B4 & "!T10:$T$24"),MATCH(C$3,Sheet2!$Q$10:$Q$24,0))
and drag it down and to the right
Sample file is attached
Great thank you all so much for your help!