Looking for some advice please on the right code to do the following;

- Import a user defined *.xlsx file into a macro enabled workbook.
- The macro enabled workbook will have a number of pivot tables and summary worksheets already setup to act upon the imported data set.
- The import *xlsx is made up of 3 worksheets titled "Rack", "Chassis", "Card", and they are also considered Tables ie. Table1, Table2, Table 3
- I am needing all 3 worksheets to be imported and retain their table1, table 2, table 3 attribute so the established pivot table references work.....

Alternatively,

Is there a way my macro enabled workbook pivot tables can dynamically point to a user defined file location? ie. User hits macro button, gets prompted for a file location and the pivots dynamically point to the location and act upon "Table1", "Table2" and "Table3"?

I don't necessarily need the workbooks merged, so the later option would be a better option if it's doable.

Note: My VBA skills are non-existent so please feel free to dumb this right down for me.

Any help is greatly appreciated