Sort formula or macro

I need to sort the following data in excel: High to low, left to right via price

So this is the problem I have to price check a number of products (each represented by a row). There can be up to 3 price checks per row and the data needs to be sorted by price from high to low, left to right but the relevant price check information need to remain intact.

Store, Price, Shipping, Total (hidden), Url.

Simply put i need a formula that can turn the data in row 4 to look like that of row 5 in the attached file Freelancerjob.xlsx

Can anyone help? Ideally this would be a formula or code that automatically sorted the data on entry.

S