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?