Combine 2 Pivot Tables into 1 Master Workbook?

[malexandria]

Hello,

I have two Excel Workbooks with a master pivot table. The Pivots use a
drop down list that I created on a separate sheet. It's set up this way
so that two different managers can work on their own sheets without
overwriting the other. This part works great. Now what I'm trying to do
is have both of these separate workbooks feed into a Master Worksheet
for the Sr Exec. The Master Workbook will pull it's data from the two
Mgr workbooks.

I've tried opening up a blank Workbook and using the Pivot Table wizard
but it's not recognizing the files. How do I do this?

Thanks in advance for your help.