OK so you want to hook into another external list, and create a tab for it? That is really complicated, with path names and such. Let us start with dynamically creating the tab. what do you think about starting there?
Let us know where you get stuck, as we do not provide turn key solutions, but help when stuck. Post some code and we can guide you. I like to start with making a MACRO and reverse-engineering it to fit my needs. Like so:
' Macro1 Macro
' Macro recorded 10/15/2015 by a BAD-A$$ MFR
Sheets("Sheet4").Name = "tab four"
You will notice where I select Sheet1, cell A4, that value is what was copied, which happened to be the name of the tab "tab 4".
I hope this makes sense, as now all you need to do is loop through an array, creating and renaming each tab!
I have said it once, I will say it again. IT!