Nope, I had to go in and change the formulas such as = SUM(D5:D999)+('2013 Ken'!D2+'2013 Pete'!D2) to = SUM(D5:D999)+('2014 Ken'!D2+'2014 Pete'!D2). Then I just noticed that the "copy" isn't a true copy as certain characteristics didn't reproduce, such as frozen columns and rows.