Update a range to include newly inserted worksheet

I have a timesheet at work that I am keeping a running total of personal/vacation and total hours worked. The timesheet is on a separate work sheet than the totals. Each week I insert a new timesheet to fill in via a template. I was hoping to have the range that resides on the "totals" worksheet update to include the newly inserted worksheet. Is there any way to accomplish this w/o having to manually change the "totals" range to include the new worksheet name?

Thanks,

Matt

Hi Matt,

Here's a suggestion. On the source file, create a sheet at the end called "Spare". Then, when you insert a new worksheet, just insert it before the "Spare" sheet and it will always be included (You will of course have to redefine the existing range to include the "Spare" sheet.)