update code

[Lost]

Is there a code to update external links upon changing reference criteria. I
use alot of Sumif, sumifvlookup and vlookup formulas. I would like to skip
the data tab to update and skip the changing of criteria,saving, closing
reopening.