I have 2 excel lists, one exported from a database, the other I created.

The first sheet is of Equipment Records with the following columns:
Itemname(Column A), Itemdescription(Column B).

The second sheet is a list of parts for the various equipment records:
Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column
C).

How do I make a sheet 3 that shows all Items from sheet 1 with any parts
from sheet 2 that they might have sorted under them?

Output Example:
Item001 Chainsaw
Part015 Bar
Part023 Chain
Item002 Pole
Item003 Mower
Part006 Blade
Part007 Belt