Quick lookup check

[Ryan1996]

What's the easiest way of me checking multiple columns between 2 worksheets?

I have two documents, both having the same columns such as:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ACTION TYPE[/TD]
[TD]TIER 1[/TD]
[TD]TIER2[/TD]
[TD]TIER3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Reporting[/TD]
[TD]GROUP1[/TD]
[TD][/TD]
[TD]GROUP4[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Manager[/TD]
[TD][/TD]
[TD]GROUP2[/TD]
[TD]GROUP4[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Access management[/TD]
[TD]GROUP1[/TD]
[TD]GROUP3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]so on[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]so on[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

And then my other workbook/sheet would be like this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ACTION TYPE[/TD]
[TD]TIER 1[/TD]
[TD]TIER2[/TD]
[TD]TIER3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Reporting[/TD]
[TD][/TD]
[TD]GROUP3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Manager[/TD]
[TD]GROUP1[/TD]
[TD]GROUP3[/TD]
[TD]GROUP3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Access management[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]so on[/TD]
[TD][/TD]
[TD]GROUP2[/TD]
[TD]GROUP4[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]so on[/TD]
[TD]GROUP2[/TD]
[TD][/TD]
[TD]GROUP4[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So the data could be different. I need to know what has changed so for example:
Is "Reporting" still Tier1=GROUP1, Tier2=Blank, Tier3=Group4 or has it changed and if it has changed what is it now?
Please note that between sheets the ACTION TYPE could be in a different row so for example instead of manager being in row 3 it could be in row 100. The check needs to be able to check all the rows for each type and then determine if the tiers have changed between sheets/doc.

We can just say the columns are as above in both sheets - A B C D. And sheets are names Sheet1 and Sheet2 or OLD DATA and NEW DATA.

Thanks guys!