This question acheives the reverse from the related question.
I have embedded a "template file - to export sheets" and want to copy and paste 2 sheets, "CalcA" & "CalcB", into any of the available excel files in the computer (this has already been achieve by Nutsch and sdwalker - by providing a dropdown list with the excel sheet which are opened at the time; I have attached their solutions as well).
The trick, is that the formulas of these 2 sheets are "replaced" so that they point to the new workbook - otherwise the inserted sheets would still be pointed to the template file.
I have added the previous solution from Nutsch and Sdwalker, to show how the pop up was handle to show the excel files opened at the time.
Solution: One possible solution could be to change the workbook name in the template file FIRST, move it to the new workbook, and then close the template file, without saving - all done by the macro. Just food for thought.
JP template-file---to-export-sheets.xls Sheet-with-real-data.xls nutsch-solution---import-data.xls sdwalker-solution---import-data.xlsm