ok... So, my guess is that since B-AF is 31 cells, they represent the day of the
month.
your rows must represent... people?
so, say for January, you have a tab/sheet called "January"
with all of the people's names in column A, and someone places a H,HD,or S in
the
appropriate Column for that person/day.

Now, for the Summary page, you're wanting to copy  the cells  containing the H,HD,
or S to that
page... what else? Name? Month?
How many rows are on each monthly sheet? Variable number?

We do something similar, but instead of the sheets for each month, we use
sheets for each employee. that way, "my" sheet  is the annual attendance report.
We also use it for scheduling the vacation, then enter the hours taken once they
are used.
The summary page then shows how many people are scheduled to be off on a given
day.