Hi,
I have a worksheet with multiple reports in it. Each report has report name, description and columns, I've copied a sample below. How can create a new workbook for each report.

Summary of Advertisers, Revenue and QCEs
South Hampton Roads Market
Source: STARS / ICVP, 12/10/2003 (Tompkins)

MARKET MARKET_NAME REV01 REV02 REV03 REVGAIN02
76618 SOUTH HAMPTON RDS 2,362,440 2,387,894 3,167,806 1.1%
76642 PENINSULA 1,632,760 1,711,185 1,268,229 4.8%
76842 SUFFOLK 310,437 295,856 4,906 -4.7%

4,305,637 4,394,934 4,440,942 2.1%


Summary of Advertiser Activity
South Hampton Roads Market
Source: STARS / ICVP, 12/10/2003 (Tompkins)

PUB_YR MARKET MARKET_NAME STARTING_REVENUE ENDING_REVENUE START_ADVERTS
2000 76618 SOUTH HAMPTON RDS 2,151,773 2,295,891 7,073
2000 76642 PENINSULA 1,563,321 1,620,962 3,790
2000 76842 SUFFOLK 294,974 313,986 415
4,010,068 4,230,839 11,278



Thanks!
Shaun