Shane Devenshire, I find it easy to do. Thanks for the idea. It works!!

"ShaneDevenshire" wrote:

Hi,

1. Open all the files at once or as many as you choose.
2. Choose Window, Arrange All, Tile
3. To copy the sheet from one workbook to the other hold down the Ctrl key
and drag the sheet tab from the source workbook to the target workbook
3a. To move the sheet from one workbook to another just drag, without the
Ctrl key.
--
Thanks,
Shane Devenshire


"Edwin" wrote:

I have more than a dozen of files. I tried moving it individually. Its time
consuming and Excel closes down. Could you tell me some method with fewer
steps?

"David Biddulph" wrote:

Yes.
Use the "Move or Copy sheets" option to copy sheets into one workbook.
--
David Biddulph

"Edwin" wrote in message
...
I have several workbooks with different types of statistical data. I want
to
combine all the workbooks to a single workbook. Is it possible?