Changing links to external workbooks

Hi all,

I have a workbook set up, let's call it workbook A, and it currently references information in workbook B.

Workbook A row 1 has a list of links to set cells in workbook B. 

I want to copy row 1 into row 2 and keep the same cell links but link it to a new workbook, workbook c. 

I tried highlighting row 2 and editing the link in data>queries and connections>edit links but it also changes the data in row 1. 

My question is, is there a way to change all the links in row 2 to link to workbook c without manually entering the new workbook link into each cell? 

Thanks for your time and hopefully the above makes sense!