I need an excel expert

Job ID: 34188613

Budget: £10 – £20 GBP

From the 'TOTAL SPEND' tab, I need to organise data into 3 categories - High, Medium, and Low.
It needs to be a table that shows the supplier Name in one of the above three categories

Low = 10,000 or less
Medium = between 10,001 and 49,999
High = 50,000 and above

Ideally a formula set up so any new supplier added will automatically appear in the table in the relevant column
Related categories: Visual Basic Excel