Formula to pull only the differences between sheets

[nordicmetal]

Hi! I have used If/Countiff/Index formula's to pull fields but this example has me stumped. I have 5 sheets in my workbook. The first, Sheet A "OCC-GEO" have what the OCC and GEO codes should be for employees in E and F columns. The next two sheets, sheets B and C, are what codes each employee currently has in separate sheets for each field, both in column G. The next two sheets, sheets D and E, I am trying to pull only where there are changes between the new codes on A and the existing codes in B and C sheets. Any ideas how this can be done? FYI, I don't know if I can create a minisheet across 5 different sheets in my workbook and can't upload the workbook itself.

 

[Radoslaw Poprawski]

please provide minisheet or link a file.

 

[nordicmetal]

How can I do that across 5 different tabs?

 

[Radoslaw Poprawski]

there is a link to xl2bb addon in my signature.
you can use ecelonedrive feature to generate link to a file which can be posted here (file, share)