I have to create several different files that have a formula that references a different worksheet. For instance cell C2=E2+'ABC'!C2, and there are multiple cells with a similar reference. The next file that I will create I will save as, and then I need to update the formula to reference a different worksheet name, say 'ABCD'!. Normally I would just find replace for the worksheet to update all the formulas. However I was wondering if you could have a cell on the worksheet that had ABC, ABCD, etc. in it that could be used in the formula that way I could update the one cell each time I created a new file and everything would automatically change.