pivot table across multiple sheets

[stephkc24]

Hi,

I'm trying to create a report using a pivot table that crosses multiple sheets. I am new at pivot tables and would appreciate any help.

First tab "Mike's Crew" has the following information

Project	Type	Cost Center	January	Feb	March
Matt House	New Home		7500	21000	2250
Matt House	New Home	Foundation	1000	10000
Matt House	New Home	Roof	2000	3000	500
Matt House	New Home	Windows	500	5000	750
Matt House	New Home	Labor	4000	3000	1000

<tbody>
</tbody>

Second Tab "Joe's Crew" has the following information

Project	Type	Cost Center	January	Feb	March
Joe's Patio	Patio Repair		1900	5650	300
Joe's Patio	Patio Repair	Wood Material	1000	3000
Joe's Patio	Patio Repair	Nails/Screws	150	150
Joe's Patio	Patio Repair	Labor	750	2500	300
Matt House	New Home		27000	18000	11000
Matt House	New Home	Wood Material	15000	5000
Matt House	New Home	Roof	2500	2500	2500
Matt House	New Home	Windows	7500	7500	7500
Matt House	New Home	Labor	2000	3000	1000

<tbody>
</tbody>

The final report that I would like to create using a pivot table, would combined the two sheets together and create a report that i could use to see the prices for all projects "Matt House" and "Joe's Patio" per month. As you can see each contractor have their own sheet and i want a report that has both f them combined. Also any project can be worked on by multiple contractors as seen with "Matt House"

Thanks,

 

[Takae]

Hope this helps.

Select First tab and select any cell in the infomation.
Press Alt--D--P
Select option button (C) --- click next and one more next.
Select all range of information and click add(A) button.
Select second tab and select all range of information and click add(A) button.
Click End(E).