Best way to aggregate/compile data from a report run every month to a macro workbook

[VBAProIWish]

Hello All,

I have a report I run every month. The result of the report is on one worksheet and has about 400 rows of data and 20 columns in it.

What I would like to do is somehow copy the data from my macro each month and save either the data or the data totals to a specific worksheet in my personal.xls workbook.

The only disadvantage I can see with copying all of the data from all of the rows would be that it would be adding 400 rows to this worksheet every time, so I'm not sure I want to have my macro workbook grow that much every month.

I am thinking maybe I can simply compile the totals from each month and copy over just the totals?

I have put some thought into this and am at a stand-still.

I am hoping you pros out there can come up with a solution to this?

Thanks