I have a workbook (Main.xlsx) that needs to be copied from one folder to another on a quarterly basis. This main workbook has links to 4 other workbooks (Q1_Shop1.xlsx, Q1_Shop2.xlsx and so on).

When the main workbook is copied to the new quarterly folder, it obviously can no longer find the path to the previous 4 workbook data sources. However, in the same new folder there will be new versions of these 4 workbooks (Q2_Shop1.xlsx, Q2_Shop2.xlsx etc)

Is there a code or macro to automatically change souces to link upto the new workbooks? Thanks.