When you create the Pivot Table,
in step 2A of the Pivot Table Wizard, select
"I will create the page fields"
In step 2B, select the individual ranges and
enter in "Field one" the associated sheet name.
See:
http://www.savefile.com/files/1685275