Pivot Table Macro
 

Using Excel 2000, I wrote a macro that creates a pivot table that uses
Multiple Consolidation Ranges. What I would like to do is add more sheets to
the the pivot table. I would like to enter the additional sheet by typing it
in an input box. Each one of my sheets has a date for its name. For example
'05122005'.