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:

	A	B	C	D
1	ACTION TYPE	TIER 1	TIER2	TIER3
2	Reporting	GROUP1		GROUP4
3	Manager		GROUP2	GROUP4
4	Access management	GROUP1	GROUP3
5	so on
6	so on
7
8
9

<tbody>
</tbody>

And then my other workbook/sheet would be like this:

	A	B	C	D
1	ACTION TYPE	TIER 1	TIER2	TIER3
2	Reporting		GROUP3
3	Manager	GROUP1	GROUP3	GROUP3
4	Access management
5	so on		GROUP2	GROUP4
6	so on	GROUP2		GROUP4
7
8
9

<tbody>
</tbody>

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!