I have a 'Summary' sheet that has a drop down list of names of plots (i.e.
Plot 1, Plot 2, Plot 3, etc.). A corresponding tab named Plot changes based
on the plot name listed in the drop down box. (i.e. if you select Plot 3 in
the drop down list, Plot 3 appears on the Plot tab).

There are 60 plots in the drop down list. I want to copy all 60 plots to a
document in Word and size them such they are about 4" tall. Manually, I
could choose plot in the drop down, click on the Plot tab and copy and paste
and do this 60 times. Hopefully there is an easier way???

Thanks!