Help using INDIRECT with formula string

[DelMonte]

Firstly, happy new year!

I'm trying to convert a string of text joined by CONCATENATE to result in a formula which references a cell on another workbook (on our server but in the same location as the master workbook).

My testing of the string and formula works when I copy/paste-special into a new cell and return the correct value of the workbook.

My problem occurs when I try to resolve the string using INDIRECT. I've had a good internet and forum search with no luck. I return the #REF! error, perhaps my string isn't a valid reference?

Below are screen dumps of the formula and it's result.

A side note, I've read that the other workbook needs to be open. I've tried it open and closed on the tests (copy/paste-special) and it works both ways!

Thanks

Mike