Delay in loading selections in userform listbox

Hello,
In the attached workbook i have a list of brands and contacts.
On the brand sheet i have some of the contacts spread across and if they requested a brand then the word "REQUESTED" is populated in the contact's cell that is on the same row as the requested brand.
When i open the userform and select a contact the relevant brands are automatically selected.
The issue i am having is that it takes a long time to load every requested brand.
Any help on hastening the import would be really appreciated.

Hi Norie,
Thanks, that's much faster!
I have a newly discovered issue, after running the code on my original MAIN workbook the code only selected the last requested item??
It won't be easy to post my main workbook because of the time it will take to clean it and set it up properly because the data that populates the combobox and listbox exists on a separate workbook.
Maybe that's the issue? The fact that there are two workbooks involved?

I will work on creating two workbooks. stay tuned

No point in posting both workbooks because it worked.
Must be something wrong with my Main workbook.

Hi Norie,
I deleted the original list box and replaced it with a new one and it works! al though i am quite confused
This is not the first time i experienced something like this.
I would love to hear anyone's thoughts as to why objects can become corrupted beyond repair.