That should not matter... it is supposed to pull the data...

without having access to your path, it is hard to diagnose.

#REF usually means that the file or sheet does not exist...

D33 being a result of a formula should not matter either as long as the result is exactly the same as the sheet name it is referring to...

So if the original formula (without INDIRECT) works, then so should this one, if the workbook is open and if the result in D33 is indeed STARK with no additional spaces... did you try the second formula I gave?