Workbook connections, Power Pivot, query

[Kit Kat]

I have 4 workbooks that each contain a table with identical structure. I have connected the first two in Power Pivot.

In order to have them all connected do I merely connect #3 and $4 to each other or are they connected to either #1 or #2 workbook?

The SQL statement for #1 and #2 is -

SELECT [NCR_PLANT_2016$].*   FROM [NCR_PLANT_2016$]
UNION ALL
SELECT * FROM `G:\BDs SANDBOX\YTD OSL\ELA_NORTH_2016.xlsx`.[ELA_NORTH_2016$]
[\code]

The last two workbooks have identical names but with 2015 instead of 2016.

 

[Fazza]

add them to the SQL,

SELECT * FROM table1
UNION ALL
SELECT * FROM table2
UNION ALL
SELECT * FROM table3
UNION ALL
SELECT * FROM table4

 

[Kit Kat]

Sorry for the late reply Fazza. Worked like a charm. Thank you!

 

[Fazza]