"=Sheet3!A1" Here I want to reference "Sheet3" from another cell

[1tane1]

In sheet1, I have a formula in cell A2:
=Sheet3!D5

and in A1, I have:
Sheet3

I want to get "Sheet3" part from A1 of my current sheet.

I need a formula for A2 something like:

=XXX(A1)!D5

or something similar to the same target cell. Could you help me please?

[JungleJme]

INDIRECT is what you want mate:

=INDIRECT(A1&"!D5")

If Sheet3 is in A1 then this will return the value in D5 of sheet3...

[1tane1]

Thank you, it worked.