I have created a table of suvey results listing multiple businesses each on a
separate line with data from each business in columns to the right of each
business name.
For example:
Revenue Expenses
Company a 'Sheet1'!c3 'Sheet1'd3
Company b 'Sheet1'!c4 'Sheet1'd4
Company c 'Sheet1'!c5 'Sheet1'd5
Etc.

On a separte worksheet, I present data in summary format showing individual
businesses in comparison to the summary by using a chart with cell references
that pull data from the list.

_______________________________________________
Company e 'Sheet1'!c7 'Sheet1'd7
------------------------------------------------------------------
Average ##### #####
Median ##### #####
Minimum ##### #####
Maximum ##### #####

To change the chart presentation above to show a different company in
comparison to the summary data I can use find and replace to change the cell
references from 7 to 3 for example to change company e to company 1.

However, rather than use find and replace, I would like to be able to type
the number 3 into a cell and change all the formulas so that they now refer
to line three rather than line 7. How do I build this single variable cell
reference into my formulas.