Indirect for autofill

[GedSalter]

Hi Guys

i have the following formula which I need to autofill down to 3800 rows

A1 ON PORTAL SHEET has a code which referes to a tab sheet name
A2 refer to the cell from that particular sheet I wish to retrieve the data.

the cell the first formula is in is X1, there the formula will autofill down.


=INDIRECT("'" & A$1&"'!"&"A2")

the following rows should read
=INDIRECT("'" & A$1&"'!"&"A3")
=INDIRECT("'" & A$1&"'!"&"A4")
=INDIRECT("'" & A$1&"'!"&"A5") etc..

I have looked at many solutions but none work. Something that I thought was so simple is not working.

Thank you in advance to any solution.


regards

Ged

 

[GedSalter]

Is that the formula cell or the cell on the other sheet?


That does not seem to match the original description

View attachment 98532

yes I know. Its just the next step in my worksheet.

 

[Peter_SSs]

yes I know. Its just the next step in my worksheet.

That does not address my initial question:

Is that the formula cell or the cell on the other sheet?

Please clarify which cells the formula goes into and which cells the formula should be targeting.

 

[GedSalter]

That does not address my initial question:


Please clarify which cells the formula goes into and which cells the formula should be targeting.

 

[Peter_SSs]

Unfortunately that does not tell or show anything that answers my question. Could you not answer it with a sentence or two?