Sheet 1 is labelled “Total”, sheet 2 “Jan”, sheet 3 “Feb”. “Total” sheet has cell contents “Jan” in A1, “Feb” in B1. “Jan” sheet has 100 in A1. “Feb” sheet has 200 in A1. Traditional formula in “Total” sheet cell A2 is =Jan!A1 which returns the value 100, and formula in “Total” sheet cell B2 is =Feb!A1 which returns the value 200. Q: Can I substitute the sheet names (Jan and Feb) in the formulae with the cell contents of A1 and B1 of the “Total” sheet, i.e. formula in “Total” sheet cell A2 something like =”A1″!A1 and cell B2 likewise =”B1″!A1 ? (which incidentally doesn’t work of course!). My real data is naturally much more complicated than this, and I want to use a template to replicate to other workbooks that will have varying sheet tab names each time. I don’t believe it can be done, so go on… prove me wrong!!
