See here for info on multiple consolidation ranges with pivot tables:
http://contextures.com/xlPivot08.html

Dave

On Apr 20, 10:28 am, Sue T wrote:
Hello - I have two very large worksheets with the same type of data and same
column headings in both. I want to create one pivot table using both of the
worksheets.. I have gone into the wizard and chosen multiple consolidation
ranges and when it comes up it only gives me column, row, and data for the
choices for the layout. I use pivot tables all the time and have created
many, but this has me stumped. Can anyone give me a step by step instruction
to do this.
Thank You for Your Help!!