#ref error ='INDIRECT("B3")'!J5 using formula for sheetname reference

[ooptennoort]

J5 on Sheet2 refers to J5 on Sheet1. I want to copy Sheet 2 many times but want the reference to be dynamic (Sheetnamenumber minus 1 ie J5 on Sheet 3 refers to J5 on Sheet2 and ongoing).
I have B3 return sheetname (with =MID(CELL("filename";B1);FIND("]";CELL("filename";B1))+1;32)) and try to refer J5 indirectly to B3 but how... is it at all possible because of the single quotes... how to overcome this???
I tried:
='indirect("b3")'!j5
=indirect("b3")!j5
="'"&indirect("b3")&"'"!j5
but no luck...

 

[RoryA]

It should be:

=indirect("'"&b3&"'!j5")

 

[ooptennoort]

It should be:

=indirect("'"&b3&"'!j5")

Thank you!
But now I am struggling getting the Sheetname[n] to substract 1. Why can't I get the substraction working?
I tried:
=INDIRECT("'"&(RIGHT($B$3;1)-1)&"'!J5")
=INDIRECT("'"&RIGHT($B$3;1)-1&"'!J5")
and even
=INDIRECT("'"&"RIGHT($B$3;1)-1"&"'!J5")
(my knowledge of syntax is just so subpar)

 

[ooptennoort]

Got it: =INDIRECT("'Sheet"&RIGHT($B$3;1)-1&"'!J5") (I forgot the 'Sheet' bit)