For anybody looking for a solution to auto sort data. Took me several hours to resolve this problem but it is easier than I thought with this simple macro.

Record a new macro> name the macro Auto_Open > complete the sort (Data>Sort), finish recording the macro.

So now, every time you open your excel file it will Auto sort the data.

Ok you'll need to close down the file and re-open every time the data changes but I'm happy with the resolution.