Please note that INDIRECT() does not work on closed workbooks. You could try the add-in from MoreFunc for that