When I try to copy data from the first excel file to another worksheet in the
second excel file, the copied data appear in more than one worksheets in the
second file. As a result data in other worksheets in the second file got
overwritten with the copied data.

Anyone know why is this so? I'm using Excel 2000.