Can I copy data tables (and connections?) to other workbooks?

[Air_Cooled_Nut]

I have a workbook (wkbk1) that has a sheet with eight different tables on it. They all point to the same external Excel workbook (wkbk2) for their data. The data for each table comes from a named range. How can I copy the sheet of eight different tables (from wkbk1) to other workbooks (wkbk3, wkbk4, etc)? Is it even possible for the table and its data connection transfer with the sheet? So far I can't do it manually (no coding). If coding is required I'm fine with that, just need help with it. I have intermediate VBA coding experience. Excel 2010.

TIA!

 

[Air_Cooled_Nut]

Nevermind, it's now working like it should (right click sheet tab, Copy etc.).