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