Populating worksheet B from Worksheet A - VBA help

Hi everyone,
I have the following scenario:
I have two worksheets RAW and BOM. What I would like to do is populate the BOM sheet FROM the RAW for certain components.


For example in BOM worksheet I have VXL5-50 (highlighted in yellow). So for that component, I search sheet1--> 'connector type' column and look if that string exists. If it does, then I increment by 1 in the QTY column in the BOM worksheet

Pseudocode:
In BOM worksheet
	For each Part number
		Compare with "connector type" in "sheet1"
		If there is a match
			Increment "QTY" value by 1 in "BOM" worksheet
		else move to next row
		If row in "sheet1" is empty
			stop script

Excel file is attached at the bottom

thank you