Excel Summary Page, tabbing

[kbrothers7]

Hello,
I have a workbook where I add new tabs daily, which I would like to track results on a summary page. As I add a new tab for each day of the month, I have having trouble creating the formula to carry over the data from the new tab to the summary page.

I am currently doing this manually, but was hoping there was an option where this would be automatically generated.

I have several cells on each tab I need to carry over on the summary page. Is there a way to do this without having to retype code on the summary page each time?

Thank you.

K

 

[mikerickson]

Create a template sheet with the formulas in place and don't use it.

Instead of adding new sheets, copy the template sheet.

 

[kbrothers7]

Thank you for relpying so fast.

I can copy the template to a new tab, but Im not sure how to carry over the data from the new tab to the summary sheet without retyping the formuals in each time.

Any thoughts on how to automatically carry over the data from the new tab to the summary sheet?

Thanks again!
K

 

[mikerickson]

What kind of formulas are in the summary sheet.

One trick is to use a formula like =SUM(firstSheet:lastSheet!A1)
put all the sheets that contribute to the summary between firstSheet and lastSheet and then hide firstSheet and lastSheet to keep the user from fiddling.