Looking For VBA Script which help to Populate the result by selecting Partner

Hi Fellow Members,

Hope you are in good in health and safe!

I have an query, i am looking for Code which help to populate the list of available model by qty and its value while selecting particular Partner from drop down list.

Drop Down list is working but i am not able to create codes.

Once i select any partner from drop down list, POP-up should appears with all the models listed with qty value and sum of qty/Value.

Reference data is attached.. Working sheet is : Summary where all the data is reflecting.

Thanks in advance.