excel formula - multiples sheet

[michelesabatini]

Hi all,

is there a formula that always links a cell to a given cell of the previous sheet?

Fo instance I'm creating a lot of sheets on the same files, and every sheet reports a number in cell B3 that is +1 compared to the number shown in the B3 of the previous sheet.

So instead linking manully every single time B3 of sheet 2 with ='sheet1'B3+1, is there a formula to avoid the manual plug in formula?

Thanks

[#2]

@michelesabatini without testing I believe the formula below could solve your problem.

=INDIRECT("sheet"&REPLACE(MID(CELL("filename", A1), FIND("]", CELL("filename", A1))+1, 31), "sheet", "")-1&"!B3")+1