Hi - I'm trying to set up a pivot table with a very large
dataset. I've got 110 Excel worksheets broken into 2 workbooks. Each
worksheet consists of about 5 columns of data and an average of
perhaps 7,000 rows. So we're talking quite a few rows of data,
total. Can I use multiple consolidation ranges to correlate the
information in these worksheets? I don't need to do any fancy
calculations, just a lot of filtering, summing, and comparing. Do I
need to provide more information about the particular application?

Thanks much.