macro help needed for worksheet to worksheet copy/paste

I have a spreadsheet with two worksheets, "Data Entry" and "Cumulative Report". After all data is entered into "Data Entry" and a report generated, I want to dump (copy/paste) this information into "Cumulative Report" for later use.

My problem is in absolute/relative references when I copy. I have formatted 200 rows in "Data Entry" but only around 100-150 rows are actually used. When writing the macro I would like to select row 2 and hold shift-end-down_arrow to select and copy without recording the cell addresses.

(note: I know I could copy all 200 and paste, then delete 100 lines from the end of "Cumulative Report" but I would rather not)

Any other suggestions?

Thanks,
Daniel P.