Template Sheet and Copying to A New Sheet and Updating Formulas

[Issy.87]

Hi,
We have a workbook that has a template sheet within it that is to be copied and used when a new entry is required. For instance, a every day will require a new sheet. Within this workbook there is a summary page that will collate the data entered and return summary values for analysis. Is there any way that when you create a copy of the Template sheet for the new day, that the formula in the Summary sheet automatically adds in the new sheet. I have attached an example. If I were to copy a new sheet from the Template for Wednesday how could I ensure the values in it are automatically in the Summary tab formulas, this is to reduce manually having to add the new sheet data into the formula on the Summary sheet.
Thanks!

[Gregb11]

If at all possible, I would highly recommend NOT doing it this way. As much as possible, you should keep your data in a structured Excel Table, and then you can report off of that any way you want.

I have attached a sample. Hopefully you can use something like this instead - it should save you headaches now and in the future.