You have a couple of options -

1) As stated on your profile you are using the Excel 2013 Version, which has a Data Model where you can link Multiple Columns from different tables (Like a Join). After this, columns from both the tables will be visible under 1 Pivot. (VBA Not Required)

2) Use Vlookup and make a common table with columns from both tables, and then make the Pivot..