I'm a little confused about the different types of Worksheet links and which I should use.  I've read this already but still have Q's: https://support.workiva.com/hc/en-us/articles/32709250416276-Should-I-use-links-or-connections

I've got data in several Source Workbooks that feed to one Destination workbook. The sources are all fairly complex with a lot of worksheets.  And I need to pick small amounts of data from all over the workbooks.  

So I've been using simple Linking and pasting the links from the fields I need.  This works fine.  Except what if I want to change the source files?  Is there a way to do that without relinking everything?  The usecase would be a new version of a source workbook. I suppose I could just copy over the data (or use excel synch) and then just publish the changes.  But is it possible to switch the source in bulk?

Alternatively, it seems that this is what Connected worksheets are for, however the data is strewn across many worksheets in each source.  And Connections seem to be Worksheet specific, and it doesn't make sense to create connections for all that data when I just need 40 data points across maybe 20 worksheets. 

So, is it common to create a NEW worksheet in each Source workbook for interface purposes, paste the fields I want to share to other workbooks in this worksheet, and then share that worksheet via a connection?  And then I can also change connections?

The only problem is the client doesn't want the original workbooks changed in anyway.  (Also, the bigger goal is to replace all this cross linking with wdata fed from SQL)

Thx!