I am rewriting some inefficient workbooks and need to extract data that someone has hardcoded into about 800 formulas.

The formula typically looks like this:

=INDEX('FE UT Feed'!$A$1:$F$4123, MATCH("PLUKBA",'FE UT Feed'!$A$1:$A$4123,), MATCH("Mid Price",'FE UT Feed'!$A$1:$F$1,))
I need to extract the PLUKBA code from this formula and place it in its own cell.

Is there a way I can do this using either a conventional formula or VBA code?

Thanks for any help!