In B1
=INDIRECT(A1&"!A1")

If this post helps click Yes
---------------
Jacob Skaria


"Neil Pearce" wrote:

Good morning,

On my summary worksheet Cells A1:A50 are the names of the 50 other worksheets.

I wish to insert Cell A1 of the repsective worksheets adjacent to the tab
names in Column B, e.g.

Cell A1 Sheet1
Cell B1 ='Sheet1'!A1

How would I change this formula to refer to column A on my Summary worksheet?


Kind regards,

Neil