Have a look at the INDIRECT function in XL Help. I think this is what
you are after, though it is not very clear from your description.

Hope this helps.

Pete

On Dec 18, 12:34*pm, Phil wrote:
I have an attendance roster with names down the left and dates across the top
in sheet1. *I mark a cell if present. *I then have detail sheets that have
all the persons data. *I would like to define a cell in the detail sheet that
is what row the data is on and then use a command like ='Sheet1'!D (plus
contents of cell on current sheet). *Something like ='Sheet1'!D'Sheet2'!F1 *
My goal is to have a formula that I can copy from sheet to sheet and simply
change the value of row reference in a cell.