Presumably you want to sum data from that range? Try this:

=SUM(INDIRECT("'"&ROW(A1)&"'!B3:E3"))

then copy that down as far as you need.

Hope this helps.

Pete

On Mar 9, 9:37*am, Lisa wrote:
I'm trying to create an analysis sheet that gathers data from 100 worksheets
within the same workbook.

I want the same cell reference in each sheet, but to change the sheet number
in each cell.

The worksheets are named 1 - 100

Here is the formula: ='1'!B3:E3

It changes the cell references only, not the worksheets.

I've changed the formula to keep the cell references: ='1'!$B$3:$E$3

I now need the formula to increment the sheet number each time, PLEASE!!!

Thanks, Lisa