Adjust formula to allow for changing sheet reference.

Hi JB,

That doesn't seem to be what I am looking for. I attached a small sample wb so you can see what I am trying to accompllish.

On the PAT sheet starting in cell A2 I need to copy the formula to the right over 90 columns but with every cell stating in B2 the formula needs to reference sheet '2' and so on until '90'.

Again, I was using the Indirect formula which worked fine, but now with the spreadsheet getting bigger and the volatile nature of the Indirect I needed to change to another formula so I went with the Index/Match.

Index/Match works fine, but without manually changing all of the sheet references how can I automate the process.

If this is possible then I can even do away with the Index/Match and just simple go with '1'!A1,'2'!A1,'3'!A1,'4'!A1,'5'!A1,'6'!A1,'7'!A1 and so on util '90'.