Pull Data from Various Worksheets into a Summary Sheet

Hi,

The problem would have been quite simple if we had a specific number of worksheets in my workbook. Please have a look at the attached worksheet.

I will be adding tabs as the year goes on. There will be 1 summary page, 1 tonnage report, and then extra tabs added to the middle. Each tab is a record of a delivery. There will be appx 500 tabs by the end of the year. So I would need the summary sheet to update automatically (or have a "run" button that could be pushed to get a process to run) whenever new delivery records are added. We will also add rows/data to the tonnage report tab (as referenced in the comments I included on the spreadsheet). It is worth mentioning that every worksheet that I insert in the middle of the two i.e. summary sheet and tonnage report, will have the same format. I just don't know how to automate the process.

Any help is appreciated.

Regards,

Zee

P.S. All the requirements have been explained full in the workbook.