The first page of the Pivot Table Wizard has a 'Multiple Consolidation
ranges' option. Choose this and follow the wizard.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Larry D Watts" wrote:

How do I specify multiple worksheets as data input for a single pivot table?