I'm not sure if I'm explaining this clearly, but...
I'm creating a report that references an database exported excel file. The problem is I need to replace several worksheets with Year-to-date numbers.

Is there a fast way of deleting an old sheet and replacing it with a new one without removing the sheet reference in a reference formula?

ie. New Sales (from May) replace with New Sales (from June) without haveing having the vlookup give a #ref error in the sheet reference.
Thanks!