Does this help?
http://www.freefilehosting.net/download/3ej13

Regards,
Ryan---

--
RyGuy


"Herbert Seidenberg" wrote:

In step 1 of the Pivot Table Wizard
make sure you selected
Multiple Consolidation Ranges.
In step 2b, the three sheet ranges are listed as
defined names.
Insert Name Define Dat1
=Sheet1!$A$3:$B$6
Notice that the range includes a column
to the right of the numbers and a row on top.
I recommend that you start out using my file
as a template, patching your data into it.