Formula to pull through data - changing sheet name

[emilybrush]

Hi All,

I'm looking for a formula to pull data a one cell in another sheet into a table on our summary sheet. The sheet name is contained in row A, the sheet name will increase by 1 for each row in the table. E.g. A3 = CR1, A4 = CR2.

Is there a formula which I can use in my table which will pull across data from cell C6 in the corresponding sheet (as named in row A)?

Thank you!

 

[Fluff]

How about

=INDIRECT("'"&A3&"'!C6")

 

[emilybrush]

How about

=INDIRECT("'"&A3&"'!C6")

Amazing - thank you!

 

[Fluff]

You're welcome & thanks for the feedback.