On Jan 30, 4:24*pm, "Max" wrote:
For clarity, let's assume you have the sheetnames in A1 down,
the actual cell refs in B1 down, eg

in A1: X, in B1: A1
in A2: Y, in B2: E5

You could place this in C1:
=INDIRECT("'"&A1&"'!"&B1)
and copy down to retrieve
in C1, the equivalent of: =X!A1
in C2, the equivalent of: =Y!E5
and so on
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---
Max, That's great, but what about the second issue about thew downward
cells as below.

When I drag the cell the values in the rows and column part of the
formula increments, but I require it to stay at A$:A or 1:1

Many thanks

Stephen