work books only reference sheets in same folder...
 

I have a series of workbooks that I have copied into multiple folders. What
I want to do is create templates of these workbooks that, when copied to a
new folder, will automatically only reference the workbooks in the new folder
instead of the source folder of the copy. The only way so far is to change
the references for each cell, in each workbook, in each folder. Any
suggestions are welcome. This is not a pressing matter but a promotion could
be on the line.