Sorting data

[Adamjonsmith]

Hi All

I'm having a nightmare Monday and could really do with some help... or a hug
I have been given the sheet I have attached and asked to sort the data into the correct columns... simple!
BUT
I have also been asked to put in place a way of sorting this automatically. To be honest I have no idea where to even start.
The normal functions that I use in excel (sumif, vlookup, match, index) all need set data to reference...
If anyone out there knows how to do this I would really appreciate the help before it makes me bald

Thanks in advance
Adam