VBA Seachable Dropdown list on multiple rows from same list

I have gotten as far as creating a dynamic searchable list however I want to be able to use it on several different rows using the same list.
The list I want to use is in Materials! B7:B1069 and for each of the sheets I want a combo box for every row, upto around 100 rows.
In a futuristic ideal world would like the prices to also copy across from this, but is way out of my depth and brain power.
Thanks for looking.