You can use INDIRECT, with the name of the worksheet in a separate cell. For
example, if the cells with the worksheet names are in A1 to A12, and you want
to retrieve the cell C3 from all those worksheet, this formula on B1 (copied
all the way to B12) will do the trick:
=INDIRECT(A1 & "!C3")

Hope this helps,
Miguel.

"Eddie P" wrote:

I'm creating a list of data found in the same cell on 12 different
worksheets. Is there an easy way to do this rather than write 12 separate
formulas?