If the sheet name has spaces in it you will have to wrap the
path/filename and sheet name with apostrophes.

INDIRECT( ) can only work with files that are open, so this might be
another problem.

Hope this helps.

Pete