I have an Excel workbook with a "total" sheet and 5 tabs. I want to add a new tab 2 or 3 times a week. Can the total page be made to "see" the other tabs that I add or do I have to modify the formula every time I add a new tab? Using Excel 2007

Thanks