Hi

take a look at Ron de Bruin's site.
Lots of example code there for dealing with most scenarios
http://www.rondebruin.nl/tips.htm
Scroll down to the Copy/Merge section

--
Regards
Roger Govier

"YM TEO" <YM wrote in message
...
I have about 24 different workbooks which had a different worksheet,
maintained by different users.

Some time to analysis the data, I have to open up all the workbooks and
move
the worksheet over manual to form an new workbook.

Is there a command which will copy the data over from each worksheet to
one
master workbook, with 24 dofferent worksheets?