Increasing Sheet Numbers by one on fill down command
 

Hi everyone - hope someone can help me
I created multiple sheets with the same formulas, now i need a report sheet
to collect information from these sheets:
Exp: Sheet1, Cell A1 = Sheet2, Cell $A$1
Sheet1, Cell A2 = Sheet3, Cell $A$1
Sheet1, Cell A3 = Sheet4, Cell $A$1
If I want the cell number to increase by 1 I remove the dollar sign, but I
can not find a way to increase the sheet number by 1, and having 250 sheets
it will take ages to adjust manually.

Can anyone help me please?

Thanks

Increasing Sheet Numbers by one on fill down command
 

If you sheet names are sheet1,sheet2..... sheet30
Then copy this formula in A1 and copy down

=INDIRECT("Sheet" & ROW()&"!A1")

You can also do it with a macro
http://www.rondebruin.nl/summary.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"albertmb" wrote in message ...
Hi everyone - hope someone can help me
I created multiple sheets with the same formulas, now i need a report sheet
to collect information from these sheets:
Exp: Sheet1, Cell A1 = Sheet2, Cell $A$1
Sheet1, Cell A2 = Sheet3, Cell $A$1
Sheet1, Cell A3 = Sheet4, Cell $A$1
If I want the cell number to increase by 1 I remove the dollar sign, but I
can not find a way to increase the sheet number by 1, and having 250 sheets
it will take ages to adjust manually.

Can anyone help me please?

Thanks