Good idea to forget sheet 2. It was basically just going to be a copy of sheet 1 anyway.
Well, to simplify things a little, I've made some changes to the original work book set out and moved away from macros and gone to formulae instead.
If you have a look at my latest sample:-
you will see that I've created a work book with twelve month tabs and a Summary tab. This can be used as a template for continuous yearly use.
In the Summary sheet, you'll see the headings that you want to summarise as per your last post but this time they are arranged vertically with the months across the top horizontally. I've only done a little formulating just to give you an idea of how the Summary sheet works in conjunction with the monthly sheets. To test it yourself, just add some more text to the rows I've already placed some in (horizontally) and see how the values change in the Summary sheet. I've also added a summary at the bottom of the dataset in each month sheet which will act as a check and for the Summary Sheet to draw its values from.
You can filter on Column A in any sheet to quickly access any information that you may need.
A few of questions for you:-
1) In the Dx row, will "Asthma" be the only word that is typed into this row, cell by cell?
2) For all the other rows in the month sheets (only the ones that need to be summarised in the Summary sheet), which will be text and which will be numeric?
3)If they are text, what text do you intend to use?
I hope that we are closer to the required result this time!