Production report

Good evening,
I have a spreadsheet which calculates an inventory of aggregate. One tab calculates a marination report for different aggregates made, the hot plant tab calculates aggregates used during ac production. I currently have tabs for 31 days for marination and tabs 31 days for AC production. The agg inventory tab summarizes how much is made, used and left in inventory. I need a macro which will eliminate the 31 tabs of each and just have one marination tab, one hot plant tab and the inventory tab based on a daily production.
I have tried numerous times to upload the spreadsheet with no luck, keep getting a database error

Can you help me?

Gary

Thanks for the info Roger.

I guess I didn't make it clear that I am marcro and VBA illiterate.
I've attached a shortened version of my spreadsheet. I need a starting point on where to insert the code and how to make it function in my spreadsheet. I don't know where to begin.

Thanks,

Gary