How do I amend an indirect formula so I don't have to type the cell reference into another sheet?
I found Ashish Mathur's rather brilliant way to generate a list of worksheets. Now I want to use an indirect formula to reference a cell on each of these sheets without having to put the cell reference into the summary sheet. How do I do that? Am attaching what I have. indirect_cell_reference.xlsx