Pivot Table in Excel 2000
 

I have an excel document with 6 spreadsheets. Eevery spreadsheet contains
some common columns and some not.

I am looking to do the following:

1. Create pivot table spreadsheet based on three common columns across
spreadsheets.
2. The page drpop down box is going to reflect the distinct value of
column 1.(It could be all)
3. The row value is represented by column 3
4. The column identified by the drop down of distict values of colum2.(it
could be all)
5. The value is the count based on grouping of column 1,2,3.

I am able to do this for one spreadsheet. How do you do it for 6?

Thanks in advance