formula not working

[JOEE1979]

Hello,
I'm not sure where I have messed up this formula
='(A1-1)'!B6725
---------------
Cell A1=2025 (next year)
I have a page that is named 2024 (current year)

I want to create the formula so it would make it easier to copy the worksheet and continue for next year.

If someone can help me, I would appreciate it

Thank you

 

[kvsrinivasamurthy]

Try

=INDIRECT("'"&A1-1&"'!B6725")

 

[JOEE1979]

it worked, but I cant seem to copy it for the lines below
for example
=INDIRECT("'"&A1-1&"'!B6725")
=INDIRECT("'"&A1-1&"'!B6726")
=INDIRECT("'"&A1-1&"'!B6727")

 

[shaowu459]

it worked, but I cant seem to copy it for the lines below
for example
=INDIRECT("'"&A1-1&"'!B6725")
=INDIRECT("'"&A1-1&"'!B6726")
=INDIRECT("'"&A1-1&"'!B6727")

=INDIRECT("'"&A1-1&"'!B"&ROW(A6725))

 

[JOEE1979]

awesome, thanks