Just thought I would post a work around that my colleague helped figure out - if you create copies of your tabs and then paste values on one tab, then only keep the 2 links on the other tab, then have a variance tab of the 1st two copies, you can paste value add the variance tab values to the tab with the 2 links left and this gives the same result. This is a work around for anyone that is following this posting and wants a result. Thank you for all your input everyone!