Code to delete filepath in linked sheet

Hello,

I have two workbooks that are linked and do calculations giving a result with numbers based on sheets within both workbooks. However, when i copy these workbooks the filepath remains to the original file. The folder name will change each time. I need some code to eliminate the filepath and just keep the specified link.

It appears like this in the formula bar:

='C:\Users\vanderp\Desktop\Master Folder\1. Operations & Tasks\[Tasks 001-025.xlsb]001'!$AR$16

but it needs to be this:

='[Tasks 001-025.xlsb]001'!$AR$16

There are hundreds of links to different cells. If I could get some sort of code to eliminate everything between ' and [ in the formula bar that would be perfect as the links would then only recognize the workbook that is open.