More efficient way to change source links for multiple tabs?

[rlexcel101]

I have copied over multiple tabs however, I need to change the source links different for each. When I go to the tabs in Data Links it ends up updating all tabs.

I tried Replace but it constantly asks me to confirm/click the file in the folder and is taking forever. Is there n easier way?

 

[rlexcel101]

any help would be greatly appreciated

 

[rlexcel101]

bump

 

[rlexcel101]

bump