Combining two Pivot Table

This one is stumping me.

I have two sets of data about each one of my employees.

Using a PT is great to summarize the data but I want to combine the results and I can't figure out how.

I have attached a quick summary (mine is actually more complicated).

I want to show how much travel and how many call Bob did, etc.

The source data doesn't lend itself to being combined that easily since they are big worksheet and have a ton of different columns.

Do you guys have any suggestions?

Thank you for your help.

In a new worksheet you could use msquery to select the required columns from the first data sheet and do a "union all" with the equivalent columns in the second data sheet. This would give you a single worksheet or data array in the new work book (with all columns lined up) to do the pivot table on.

Thanks!! That will help. I knew I just wasn't approaching it the right way.

I appreciate the help.
-TK