Try this...

Assume you enter the first formula in cell A1:

=INDIRECT("'"&ROWS(A$1:A1)&"'!D17")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Neil M" wrote in message
...
I have a workbook with a summary sheet for 25 other sheets. On these 25
sheets there is a cell that is the same cell on every sheet, but may
contain
different values based on formulas within the specific sheet.
In other words, cell D17 on sheet '1' will be different from D17 on any
other sheet.

On the summary sheet row 1 would refer to sheet 1. I need the cells in row
1
of the summary sheet to look for specific values in a specific cell on
sheet
1 and simply copy the value.
When I simply enter ='1'D17 it works, But when I try to copy that formula
down the column it comes out in row 2 as '1'D18 instead of '2'D17.

I either need a formula that will reference the proper sheet or find a way
to enter the formulas in the first row and be able to copy them all the
way
down and only change the sheet number, NOT the cell number.

I hope I have provided enough information.