Hi,

You are making the same mistake that I see time and time again. You are mixing up the two elements of data capture and final reporting. The two require quite different treatments.

A lot of people start by designing the form that they expect to see as the final report, and then wonder why it's so difficult to subsequently analyse and summarise or extract information from it, Yours exhibits all those features.

You should always capture data in a simple two dimensional table and worry about reporting information from it afterwards. Without exception doing this you will always be able to easily obtain management information. Rarely is this the case if you start the other way round.
You will also throw open the whole wonderful world of the powerful Pivot table functionality.

So:
1. Combine all the data from your monthly sheets into one sheet in a simple two dimensional contiguous table.
2. Add an additional (say first) column which contains the month start date.
3. Make sure that there are no column or row gaps.
4. Place meaningful column labels at the top of the data. Create a dynamic range name that will

Now you'll find that you can use a Pivot table to summarise (and analyse your data). In addition since you now have a 'proper' database you can use standard data filter/advanced filter to view or extract records for reporting.