Value of same cell on multiple worksheets, in a list.

[AntBlabby8]

I am just getting back to Excel after an absence (semi-retired). I want to make a list of value in the same cell address on 52 worksheets. It occurred to me that if I made a column of worksheet names (Week1, Week2, etc.) and then concatenated each one with the same cell address, I could do it that way. So Column A would have the worksheet name, Column B would have the cell address (i.e., A1) and I could just chain them together and get the value in that cell on 52 rows. It doesn't work. I put Week1! in the first cell and C5. When I concatenate them, I get text and that's it. I know there is a way because I've done something similar before. HELP! and THANKS from this rusty brain.

 

[Artik]

INDIRECT function?

Artik

 

[AntBlabby8]

It worked! Thanks! Rusty brain waking up, too.