excel function

[thangtv23]

Hi guys
I have a small problem that I hope you can help me with
As shown in the image of column H, I want to refer to other sheets, the name of the referenced sheet is in column G, I don't know if there is a general formula for column H.

[#2]

Hi @thangtv23 

You would use this formula

=INDIRECT("'"&G26&"'!J26")