I have a sheet named Consolidated. It contains all data that I need to compute and segregate to each sub category.

So what happens in this report is this:

1) Get raw data from system
2) Dump to Excel Sheet
3) Process it and transfer to Consolidated Sheet
4) Compute for each Sub Category and segregate per hour per sub category
5) Repeat from 1 throughout the day