INDIRECT will only work if target is an open workbook (it can be as dynamic as necessary regards file names, sheet names & cells).
If in your case (as implied from the links) your target files are closed then INDIRECT per se is not viable and you may want to investigate Laurent Longre's morefunc.xll add-in & specifically the INDIRECT.EXT function.