Pivot table with multiple horizontal (365) tables

Hello,

I am trying to make a pivot table with multiple horizontal tables (a production schedule for a year). I need the table to see each range and consolidate the columns with the same headers.

I have attached an example with multiple tabs;

Year Schedule: The year schedule I have created that my production staff will use. Unfortunately I can not change this style of layout. I work as a scheduler for a concrete company and I need each day as a seperate table that can be print off as a "daily" schedule

Sheet 2: Shows a pivot table with only 2 dates this is exactly how I want the table to show for the whole data set in "year schedule"

Sheet 5: I attempted to use the Pivot wizard to do what I need but it labels each identical header as a series (ex, ESOR, ESOR2, ESOR3...)

Sheet 3: Not important

Dummy info: One possible Idea I came up with is consolidating all the tables into one. It would for the few dates I tried with but I need to fill out the whole year and if I add a new row to "Year schedule" I need the pivot table to update which I am note sure it will do with the way I have "dummy info" set up.

Note: The file is 2mb so please use this dropbox link to download

https://www.dropbox.com/s/aisw6glwal...raft.xlsx?dl=0

Any help is much appreciated! Thank you in advance