Inserting entire excel page in another page

I have two workbook pages... One is weekly report, the other is monthly report.
I would like to have all of the content from weekly report, automatically show up in monthly report, once the weekly report has been created. The challenge is the rows and columns will change automatically with each passing week. I'm using Urchin which exports the data to excel, depending on the site traffic, the information rows will change.

I tried a simple paste special function, but received an error message of "not able to link". I'm assuming its because its an entire page, not just a single cell.

Am I missing the obvious here?

Thanks,
Ryan

do you have a separate sheet for every weekly report, or a single sheet overwritten each week?