First, this doesn't make sense to me:
Originally Posted by
nathan488
has to be import as there's merged cells, loads of rows etc in the closed workbook so can't copy
There is no such thing as "import" a workbook. If you copy the sheets, they will preserve merged cells and everything else.
To copy sheets from a closed workbook, you have to open it. If the code is located in the same workbook that is to receive the sheets, you want something like this (untested though I would test if I had your files)
Bookmarks