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

ROW1 GridName

Page1

Page2

Page3

Page4

Page5

Page6

Page7

Page8

Page9

Page10

Page11

Page12

ROW2 AMT002

10857

10858

10859

10860

10869

8007A

ROW3 BG876

10036

10085

10099

10111

10380

461R

8007A

<tbody>
</tbody>

Sheet2 ROW1 GridName Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10 Page11 Page12 ROW2 AMT002 10857 10858 10859 10860 10869 8007A 30987 44532 ROW3 BG876 10036 10085 10099 10111 10380 8007A <tbody> </tbody>

<tbody>
</tbody>

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!!