Anybody got any thoughts on this or can improve the code  i already
have.

What i'm trying to do is collect the info so that it can be printed
off.

It's a holiday/schedule control program but i only want to give
certain info to people when i print off.

I have all the months on individual sheets and on each sheet  there
are 20 people.

So i need to get info from the monthly sheets b7:af7 and paste them
into a new sheet for printing.

So copy  April B7:AF7 to Print Balance B3 but only copy "H","HD"
or "S".

Then May B7:AF7 to Print Balance B4
Then June B7:AF7 to Print Balance B5
Then July B7:AF7 to Print Balance B6
Then August B7:AF7 to Print Balance B7

and so on.

The way i have it now is to copy all the info but conditionally
format the info out by turning the Cell/Font white.