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