I would like to know how to automate the following two processes with excel:

1. I would like to take data that is obtained from 9 to 15 sql server 2000
queries
results and load the detail data onto excel spreadsheets. Each query would
be a different tab (worksheet) in the excel spreadsheet.

2. I would also like to take data that is obtained from 9 to 15 sql server
2000
query results and load the summary counts into one tab (worksheet) in the
excel workbook
3. I would also like to take data that is obtained from 9 to 15 sql server
2000 in and place the data in pivot tables for the excel 2003 spreadsheets.

Thus I would like to know what steps can be completed by using DTS and how
I would accomplish those steps.

Thanks!