I have several linked workbooks in various folders, some of which have the same names. I want to move them all into the same folder, make the names unique where necessary, and automatically update the links.
The simplest way I can think of is:
In Windows, move [and rename) each workbook into...