This microsoft article may help
http://support.microsoft.com/kb/142529/
Or this extract from John Walkenbach's book may be what you are looking for
Printing multiple ranges, from the book 'Excel bible' by John Walkenbach
You can create live snapshots of the ranges and paste these snapshots to an
empty area of the worksheet or a new worksheet. Then you can print this new
area which consists of the snapshots.
To create a live snapshot of a range, select the range and copy it to the
clipboard. Then to paste a live link, select the cell in which you want to
paste the snapshot to an empty worksheet or an empty area on an existing
sheet, press and hold the shift key, and then choose edit (from the menu),
paste picture link.
Repeat this procedure for the other ranges. After you paste them, you can
rearrange the snapshots any way you like. These are live links, change a
cell in the original range and the change appears in the linked picture.
