Can anybody help

I run every month a crystal report with approx 30 sub reports and then export into excel

Each sub report will be different and vary in size from month to month.

My question is is it possible within crystal Reports 10 to be able to set up each sub report so that when it is exported to excell the data is already named

For example data within report 1 to be exported to excel with a name of 1 and the data within report 2 to be exported with name 2 etc etc

Then what propose to do is export all this data into a single workbook for example November 10 which has a tab for each sub report so that when i click on a macro it will automatically copy the data for report 1 into work sheet 1 and data for report 2 into worksheet 2 etc etc

Many thanks

Neil