I am preparing a worksheet, and entering formulas that are referenced to worksheets that haven't been created yet. As data becomes available, new worksheets will be created and named with a proper naming convention. My problem is that although the formula is correct, after the new sheet is created my value shows REF. By simply making the formula active (not changing anything) and hitting enter, it evaluates itself and works. Is there a way to apply this to an entire sheet of formulas, without the tedious task of going cell by cell? Thanks to anyone who can help or offer a suggestion.