Can someone plz help me with this problem.
assume first of all that i open excel with a blank workbook (ie book1.)
my next step is to open (say?) three other workbooks. so,at this stage i have 4 open (shown in the window menu option after clicking it)

what i literally want to do is to run vba code once so that it iterates through the workbook collection (not including personal.xls if present) moving each of the 2nd, 3rd and 4th workbooks active sheet to book1.



thanks in advance
Gaz