OK, first of all, turning the cell & font white will NOT keep it from printing.
Your printer doesn't print WHITE, so it'll default to black.
Second... It's VERY possible to just copy certain cells.
You said "but only copy "H","HD" or "S""..
that has absolutely NO meaning for me.
Are you saying that you're wanting to copy rows from each of the sheets,
but only if they have a specific value in a specific column?
Is there a limit to the number of rows in each sheet (I suspect that there is,
but...)
It's really fairly simple, but I would NOT recommend using copy/paste.
It's VERY CPU intensive.
If you use something like:
sheets("Balance").cells(ROWNUM,ColNo) = sheets(MonthNo).cells(r,c)
in a series of nested loops, it would run MUCH faster.
If you can give me some more info, or even send me the file, I can see what I
can do.