Looking for the best way to do this please?

I have 2 extensive lists of equipment, one column on each sheet contains equipment numbers... one sheet has been stock checked and contains a 'found' yes or no column.

I want to merge the 2 lists of data to end up with one list containing the data from both sheets.

Where different equipment numbers exist between list I want them to remain untouched...

So if 123 yes is on sheet one, i want to merge that with 123 houston on the second sheet.

I hope this makes sense and thank you in advance for assistance