That is because your cell references look like this:

='C:\[file1.xls]Sheet1'!$A$1

C:\ .. This is the path to your files and when you copy them to another
location Excel is not aware of that location.

You may need to modify your formulas to reflect the new path.

I was trying to construct the path in the formula from an input cell
but wasn't successful yet.

Hans