macro to copy and paste data to new sheet

Here is you sample back, click the button and the sheets will generate, I have been trying for hours to get each sheet range to save as a .gif but I have run out of time trying to get them to work in a loop, check out these two sites they are close to what you want.

The Workbook is saved as XL'03

http://www.andypope.info/vba/gex.htm
http://www.mvps.org/dmcritchie/excel/xl2gif.htm