Auto sort columns when a change is made

So I have a sheet in a workbook that has two columns, A and B.

A - List of supplier names that are got from another sheet (ie A2.. =Sheet1!E4, for example..)
B - The corresponding "score" that this supplier got, also got from that same other sheet
(with A1 and B1 being headers, so the supplier/score start from row 2)


What I need is a way of sorting these columns so that the supplier and their score remain next to each other, but they are sorted in relation to their score, i.e highest scoring supplier at the top and lowest at the bottom. And when a score is changed, this sheet updates automatically to reflect this

Please Login or Register  to view this content.

I have this so far from a similar document I was using it in, but it doesn't seem to work in this one

Thank you for any help!