you could just open your new workbook and minmise it

then open each of the other workbooks inturn ,

select the tab with the data in and right click

select move or copy

then move the page into the new book




it is easier that it sounds and keeps the original formating ext ,,, and is
less hassel that copying and pasting accross both books



"GrayesGhost" wrote:

If an unopened Excel Workbook only contains a single worksheet, is it
possible to import the data from that worksheet into another Workbook that is
open, without having to open the other file?