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