Cells A1:A50 on my Summary worksheet contain the names of the other 50
worksheets in my workbook.

I now wish to populate column B with the contents of Cells Z1 of the 50
workbooks, e.g.

Cell A1 =Sheet1
Cell B1 ='Sheet1'!Z1

How would I adjust B1 such that the formula would refer to cell A1 and that
therefore the cell can be copied and pasted?


Yours in appreciation,

Neil