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 worksheets?

Thank you,

Gabriella