Merger excel worksheet

There are two worksheet sheet1, sheet2, requested that the work table of contents into the worksheet in sheet3.Sheet1 worksheet but sheet2 and some form of mutual cross is the cross-reference table.Sheet3 into how to ensure the accuracy of the data after And sheet3 table in the formula are not cross-reference table (that is, to quote the formula you are sheet3 object's data)

1 , To set a good shet1, sheet2 worksheet in the line out wide and high
two tables should be set to the same line, based on needs, flexibility in the use of “merger of the cell” to adjust the cell;
2, Select “sheet1”:Point your mouse at “A” list, hold down the left mouse button, slide to the right, until the entire worksheet (that is:select the entire column) after the copy.
3, to open “sheet2”, selected the work of The table on the right side of it out (the whole list) after the paste on the OK.? use copy-paste method does not work.
If the table would also like to retain the original two, my approach is:the first copy of a document 000, and the other from a different file name.
To open new files, with a way to cut the two combined to form the third in the table, and then open the original file, copy the file from the third table Until the original document, preserve and then copy the new files to delete.