VBA to compare two worksheets

Hi all -- I have a task to compare and note any differences between two worksheets (maybe by color codes). Both sheets will be similar but not exact in reference to columns and rows. We have one report coming out of one reporting tool (SAS) and another coming from Cognos. We have many reports to compare. But for the sake of this post, say I'm comparing employee data...each reports shows Employee ID, Name, Title, Department, Manager, Salary...etc. One report may have Title in column D where the other may have it in J. I'm not sure really how to do this, with Vlookup but it also need to find it anywhere in the other sheet....hope this makes sense. That is why I was thinking something with VBA but I'm not sure where to get started.

I'll have one workbook with two sheets, Sheet1 is Cognos, Sheet2 is SAS. I've included a test file with a few columns and rows...any suggestions would be great!! The actual files I'm working with can be from 100 rows and 10 columns to 15000 rows and 20 columns...As you'll see by my example, the column for Location is in column E and is called Physical Location, on the other sheet it's in column G and that is called Location_Desc. Again, another wrinkle in my task...Thanks to all for taking a look!