Hi

try this =INDIRECT(A1&"!B"&A2)

"Greggers" wrote:

I wish to reference data in variable cells, on variable worksheets, from a
fixed worksheet :

Sheet 1.A1 = name of variable worksheets (Sheet 2, Sheet 3 ...) to get data
from
Sheet 1.A2 = variable row on chosen variable worksheet to get data from
The column on the variable worksheet will always be the same, say "B"
Data to be displayed in Sheet 1.A3

All the forum Q/As I have seen reference fixed cells on Sheet 2,3 etc, not
variable.
cells. I would also be interested to know the formula if the row was fixed
and the column was variable.

Can anyone help ?