Unable to create a Pivot table from multiple tables in Excel for Mac - seriously???
Create a pivot table from multiple tables (feature appears to be missing from Excel for Mac!)
Kenneth Barber commented
I'm pretty sure that the only way to do this in the Windows version of Excel is to add the tables to the Data Model, which is part of Power Pivot. You might want to give this a vote: