Maybe in B5 coiped across and down
But if this is a trivial example and your production workbook has dozens of sheets then that would be an inelegant solution.
INDIRECT is processor hungry but it depends how much data you have. If this example data set is truly representative then I can't see it being a problem.
A neater solution would be to change your data if its spread out across many sheets. Data is always best kept on a single sheet.
In his case I'd have a new Data layout with columns for
Current Tab Name - values would be A,B,C or their equivalent
Whatever the current A:G values represent - values A,B,C,D...etc
Whatever the current B4:I4 values represnet - values 1,2,3...8
Value - i.e. the values currently at the intersections of the above
Bookmarks