=INDEX('A2_Sensitivity Analysis'!$AJ$16:$BA$31,COLUMNS($A:I),ROWS($1:25))



This worked until I inserted a few rows on the worksheet 'A2_Sensitivity
Analysis'. Now I get #REF! error. I'm trying to reference cells in column
AV, in this case row 24 on 'A2_Sensitivity Analysis'.

The benefit of this formula is that I can drag it across, and it will
reference the other rows in the same column of worksheet A2_Sensitivity
Analysis.

I tried adjusting the formula, but since I don't really understand it I keep
getting #ref errors. Any suggestions on how to modify it? thanks very much.