One way

=OFFSET(Sheet2!$A$1,ROW(1:1)*37-37,)

copy down

Regards

Peo Sjoblom

"Gary Fuller" wrote:

Hi,
We are makinga purchase order sheet that will contain may PO's. We would
like to summarize the ata on another sheet.
Each cell we need to reference is 37 cells from the previous, is there a way
to populate the references without had typing "=Sheet2!A1" "=Sheet2!A38", etc?
Thank you,
Gary