vba - Pull data from two different connections into a table excel -

I need to retrieve data from two different connection sources in Excel, then add them to a large table. These are present on different servers and I am unable to link both together in the server.

I currently have two options

1). Use the PowerPivot plugin to link two. I did this, but no solution can be found to draw the data in a table, it is only one pointable that I do not want. 2.) Write the VBA code to draw two connections, make sheets and tables for both Add loop tables and mix them in a sheet by removing two sheets. It's hard and time consuming to write and run.

Looking for priority with option 1.

Thank you!