Creating a summary table that has totals

Hello,

I am looking to solve the following problem using VBA:

I receive a data table every day of the month. An example of how the data is organized is provided. What I need to do is create a monthly summary of all this data.

Basically what i'm dealing with here is 30 separate sheets that contain the daily numbers - "daily summary" for each day of the month. I have created a macro that puts all the tables on one sheet. Now I just need to aggregate the daily numbers into one "summary" table. The table would be organized just like the daily tables, but instead of having daily totals, would have the monthly totals for each category.

Some of the daily data tables have more companies listed, while others will have less. The summary table will have all the companies listed. It's just a question of adding the daily numbers from the same categories of data together and displaying the totals in the summary table.

Any help is appreciated. Thanks!

- J