Monthly Summary at the end of the month for different criteria

[Anuru]

Dear experts,
I have attached here an excel work sheet.
Let me describe how this works;
>> this work sheet contains "sheet tabs" for each day and items/styles running in the production line.
>> Production lines are named as A1, B1 etc, and one item/style runs in a particular day.
>> The production time/duration of an item/style varies (it can be 1,2,3,5, 10,15, or any number of days depending on the order qty and daily targets/achievement.
>> A production line can have more than one/two/three or more items/styles in a month. But, each item/style has different names.
>> A month can start from any day and end in the same way, and this work sheet includes only the days factory worked.
>> The sheet tabs has some formulas in some columns/cells
>> End of the month, we prepare an item/style wise summary adding the daily information recorded on the sheet tabs.
>> This kind of work sheets are used for different factory locations (currently, I have 6 factory locations whose daily data are recorded on this kind of a work sheet)

Summary making process is time consuming and gives rise to a lot of MANUAL CALCULATION ERRORS.
I need your support to summarize daily data in to a sheet called "Style Wise Summary" using a VBA macro program.

The Style Wise Summary has different column labels which are self explained

** Columns that are in "BLUE", has the item/style basic details and these information repeat every day till the end of the style/item
** Column "I & K" should calculate the cumulative, but should be shown as an "average" as per the number of "days" style/item runs
** All "RED" columns should calculate the "cumulative/totals" of the given criteria.
** In the Summary report, all items produced in a particular line (A1, B1 etc) should be shown in the rows one below the other as per the order of progression.

Pls ask me if you need any more information.

Thanks in advance.