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.