highlight or extract data differences in rows on two worksheets

[seattlerose]

Okay all great minds out there I am at a stand still. I have two sheets with the 13 columns and ~700 rows I need to know what data is different in each row. NOT what is different by each column/cell just what data is different in each row.

Example

Sheet1
[TABLE="width: 839"]
<tbody>[TR]
[TD]ROW1 GridName[/TD]
[TD] Page1[/TD]
[TD]Page2[/TD]
[TD]Page3[/TD]
[TD]Page4[/TD]
[TD]Page5[/TD]
[TD]Page6[/TD]
[TD]Page7[/TD]
[TD]Page8[/TD]
[TD]Page9[/TD]
[TD]Page10[/TD]
[TD]Page11[/TD]
[TD]Page12[/TD]
[/TR]
[TR]
[TD]ROW2 AMT002[/TD]
[TD] 10857[/TD]
[TD]10858[/TD]
[TD]10859[/TD]
[TD]10860[/TD]
[TD]10869[/TD]
[TD]8007A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROW3 BG876[/TD]
[TD] 10036[/TD]
[TD]10085[/TD]
[TD]10099[/TD]
[TD]10111[/TD]
[TD]10380[/TD]
[TD] 461R[/TD]
[TD] 8007A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 723"]
<tbody>[TR]
[TD]Sheet2
[TABLE="width: 839"]
<tbody>[TR]
[TD]ROW1 GridName[/TD]
[TD] Page1[/TD]
[TD]Page2[/TD]
[TD]Page3[/TD]
[TD]Page4[/TD]
[TD]Page5[/TD]
[TD]Page6[/TD]
[TD]Page7[/TD]
[TD]Page8[/TD]
[TD]Page9[/TD]
[TD]Page10[/TD]
[TD]Page11[/TD]
[TD]Page12[/TD]
[/TR]
[TR]
[TD]ROW2 AMT002[/TD]
[TD]10857[/TD]
[TD]10858[/TD]
[TD]10859[/TD]
[TD]10860[/TD]
[TD]10869[/TD]
[TD]8007A[/TD]
[TD]30987[/TD]
[TD]44532[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ROW3 BG876[/TD]
[TD]10036[/TD]
[TD]10085[/TD]
[TD]10099[/TD]
[TD]10111[/TD]
[TD]10380[/TD]
[TD]8007A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

So what I am trying to extract or highlight in this example would be great if it would go to a new sheet like this
Sheet Row Data1 Data2
Sheet1 Row2 461R
Sheet2 Row1 30987 44532

I've done a compare VBA but it will only work for exact row match (i.e. looks cell by cell for each row and highlights the cell on the second sheet that is different. I need it to be the overall row not what doesn't match in each cell in a row)

Thanks for any help!!