I've created an extensive macro that produces 5 reports across 5
worksheets within a workbook. My client would like all 5 reports to be
arranged on one formatted printable worksheet. I thought I would use
Excel's copy picture function since the reports are of varying lengths
and column widths. My problem, however, is how do I code where I can
find the end of a picture is so when I go to paste the next report it
doesn't overlap?

Thanks!