You'd be better advised to upload the two workbooks so that we can can check this in context.
Presumably you are aware that INDIRECT doesn't work unless the file referred to is Open?

It's also confusing since you say the formula that works refers to B2! which I presume means a sheet called whatever is held in B2. But B2 is the name of a file.