An answer to your first question has been posted
Some of us in North America are just waking up!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Neil Pearce" wrote in message
...
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