Report formatting in Excel using "Copy picture" question

[sec12205]

I've written a pretty extensive macro that creates 5 reports over 5 worksheets. My client would like to see these 5 reports arranged so they print out on legal size paper in a landscape orientation. Since the reports are of varying sizes I thought I would highlight each report and use the "Copy picture" function and paste them all into one new worksheet. My problem is, how do I code in VBA where I can find the bottom of one report to paste another so I don't have overlapping pictures?

Or perhaps there's a better way to do this?

Thanks!