Why not use Indirect?

from
='Brisbane Metro'!G12
to
=INDIRECT("'" & A1 & "'!G12")

"Harn88" wrote:

Hi

Please help me; I need help with a Marco.

I want to be able to change a certain word in the formula according to what
is written in the cell.

For example:

If a formula in Cell A3 is as follow:

='Brisbane Metro'!G12

However if I wrote €˜Gold Coast€� in Cell A1 it will change the above formula
in Cell A3 from

='Brisbane Metro'!G12

To

='Gold Coast!G12

Thank you very much for your help!!!

Please let me know if you need more information

Best regards,

Harn