Hello,

I would like to create a table that references the same cell in variable
worksheets.

A worksheet name is stored in A12.
The cell I want to reference in each worksheet is in R7.

I was using this formula:

=IF($A$16="","",INDIRECT("'"&$A$16&"'!S7"))

However, overtime I may want to add columns/rows to the individual
worksheet. How can the cell R7 update in my formula if I do this.

Any help appreciated!

Ellen