How do I update copy of worksheet

[Al]

Is there a way to update a copy of a spreadsheet(2 worksheets of 4 on
source) without manually opening the copy and updating the links?

[wmaughan]

If I am understanding your question correctly, then when changing links, you should be prompted when re-openning the file to "Update Links" (yes, no).