Listbox filled with data from combo box selection on a userform

I have a file that I would like to be able to see part number status when selecting a specific part number from a combo box. Would also like to be able to copy selected line of data in listbox when clicked to another worksheet but having no success at all doing this. New to VBA and cannot figure anything out. Appreciate any assistance in getting started. Attached a copy of file working with.

Thanks,

Kevin