Grab sheet name from a cell

[[email protected]]

Guys,

Im looking to have excel grab the sheet name from the cell rather than manually clicking on the sheet each time. I have attached an example. I would like the formula in cells B5:7 and C5:7 to reference A5:7 rather than the specific sheet as seen in cell B5 --> =b!A1. I assume it will look something along the lines of ='(A5)'!A1, but that doesn't seem to work???

Thanks for any suggestions or a forward to an approperiate post which I was unable to find in my searches.

QAZ

[NBVC]

Try

=Indirect("'"&A5&"'!A1")

[[email protected]]

worked. thanks

QAZ