How to consolidate two excel work sheets of the same size?

[Steveclark]

There are two excel work sheets of same size. Both the work sheets have different data for the same cells. We should consolidate the data of the both the excel sheets and make a third excel sheet.

 

[qafself]

What do you mean by consolidate? An example would help.