VBA Help to SUM Cells Across Multiple Worksheets

[nhbartos]

Hi folks,

I have another workbook that I am creating and again, need your help.

I have a summary tab and I need to sum all data across all dated tabs, existing, and when new are added.
I also have a macro button to insert new worksheets, as needed. I need code to insert the new worksheet and to automatically add its data to the summary.

The data to be summed is highlighted green on summary and on the 9-25-17 worksheet.

Here is the link to this file: https://drive.google.com/open?id=0B1W8cwZVnTmPRkxHZHpMWElhRGM

Thanks!

Vin