Excel for Mac Pivot table create relationship among the tables

Hello, I need to connect (concatenate) 4 tables to prepare an excel power pivot presentation based on various data requirements. Can you please give me some instructions how to combine separate wor...