Indicate different cells in two worksheets

Hi all,

I've been struggling with this question for hours now.

I have two worksheets in one workbook.
An example of both can be found below.

How can I create my desired outcome as described in the last part?


Sheet 1 “offDB” : (contains the official database, total: 73.619 rows)

ID Model Name Manufacturer
100100 G410 Mitsubishi
100200 A53 Siemens
100300 TBD (AAB-1880030-BV) Sony Ericsson
100400 RM-669 Nokia
100500 M930 NA DB Motorola
100600 EBX700 Panasonic
100700 Tester Sony Electronics
100800 TCD718 Philips
etc.


Sheet2 “ourDB” :
(contains our own database, total: 41.470 rows)
(please note that some rows that can be found in sheet1 are missing in this sheet.)

ID Model Name Manufacturer
100100 G410 Mitsubishi
100200 A53 Siemans
100400 TRM-669 Nokia
100500 M930 NA DB Motorola
100600
100800 TCD718 Philips
etc.


Desired outcome:Sheet2:


\1

Any help is greatly appreciated!