You dont need a macro instead you can use INDIRECT()

Cell A3
=INDIRECT(A1&"!G12")

If this post helps click Yes
---------------
Jacob Skaria


"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