Macro to sort multiple ranges on a worksheet

Hi Guys -

Could someone please help me out to sort multiple ranges on a worksheet.

I have attached an excel file where I need to sort the set of data("A:H") based on column "G".

Have shown a difference of Raw data and Required output on the attached file.

All I require is to sort the set of data("A:H") using column "G" ("Status").

Any help would be greatly appreciated.

Many thanks in advance.

Regards,
Nikki