Populate table column with array

Hi,

Help with code to automatically populate the "Suppliers Assigned" column on the table contained on the "Jobs" Sheet.
This column is the abbreviated Supplier name for each order for a particular job.

I presume the best option will be VBA that runs every time the Jobs Sheet opens.

Sample sheet attached.
Not sure if it effects the code however the various tables could have filters applied when the code runs.

Thanks In advance.
Brett

Thanks that works on your attached spreadsheet. I'll have to try getting it working in my live spreadsheet now

Thanks
Brett