I have two tables on separate tabs, with the same column names. I would like to consolidate these using a Pivottable so that the 'combined' pivottable updates with the information so when reporting we don't have to review both separate tables we can look at the combined pivottable.

I have tried creating the pivottable using "Multiple consolidation ranges" but it doesn't show each project as a new line etc. This is my example...


TAB 1
Customer / Project Description / Status / Project Manager
Customer 1 / Project 1 / Open / Joe Bloggs
Customer 3 / Project 3 / Open / A Smith

TAB 2
Customer / Project Description / Status / Project Manager
Customer 2 / Project 2 / Open / Mrs Jones

TAB 3 (combined Pivot table)

Customer / Project Description / Status / Project Manager
Customer 1 / Project 1 / Open / Joe Bloggs
Customer 2 / Project 2 / Open / Mrs Jones
Customer 3 / Project 3 / Open / A Smith

Hope that makes sense - if someone could shed some light on a way this could happen that would be great!!