How to automate drop down list allocation given specific entries ?

I could have another look if you want, but not sure on the formulas needed for the reference sheet, as the supplier names will be classed as duplicates. I will have a look later.

So invoice suppliers - need all drop downs.
Information to transfer into the reference sheet from the invoice supplier columns (name, P&1 & P&L 2.)