Replace name in formula with cell reference

I tried the indirect formula with the referenced workbook open. I get the #ref error.

D33 says STARK, but it's actually a formula that creates it.
=LEFT(C33,FIND(",",C33)-1)