Formula required to bring back all values in a list based on 1 cell

Hi,

Hopefully one of you clever people will be able to help (again) - via a formula I wish to populate the yellow cells in this sheet from the list on the other one based on the code in A1 on the first sheet. There will be multiple different suppliers based on the one code in cell A1.

Many thanks in advance

Suzanne