You have one Excel workbook. You have several sheets in the workbook. You have one summary table on Sheet1 where you want to compile all results. The summary table references to three cells on each sheet. You fill in the formulas, cross-referencing the ranges, Sheet2!A2, Sheet2!B2, Sheet2!C4. This is all fine, it takes a while to do, but you will get there.

Now suppose you add 3 more sheets. You have to copy the formulas, and then change the sheet references to update your table. Quite cumbersome, but there is a solution to it, reference one cell instead of all with Excels ADDRESS and INDIRECT functions!  (more…)