Increasing Sheet Numbers by one on fill down command

[Guest]

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

 

[Ron de Bruin]

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