Creating a complex comparative table

Hi All,

I am creating schedules based on quite a large amount of information, and I'm looking for a way to create a comparative table based on two columns from separate sheets.

the first column needs to include all cells with no fill as well as all cells with a blue fill. The second column on a separate sheet must not be filtered in any way. Differences in the data must be shown.

Any ideas?

TIA