VBA Group Row Based on Cell Critieria

[unknownymous]

Hello Guys,

I have below data that I need to group based on criteria below:

Raw (Sheet1):

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD]Donna[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]05[/TD]
[TD]Karl[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]06[/TD]
[TD]Ems[/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]02[/TD]
[TD]Shawn[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]05[/TD]
[TD]Mae[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]03[/TD]
[TD]Ann[/TD]
[TD]OK[/TD]
[/TR]
</tbody>[/TABLE]


End Result:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]01[/TD]
[TD]Donna[/TD]
[TD]Done[/TD]
[/TR]
[TR]
[TD]03[/TD]
[TD]Ann[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD]05[/TD]
[TD]Karl [/TD]
[TD]Compelete[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]02[/TD]
[TD]Shawn[/TD]
[TD]Incomplete[/TD]
[/TR]
[TR]
[TD]05[/TD]
[TD]Mae[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]06[/TD]
[TD]Ems[/TD]
[TD]Pending [/TD]
[/TR]
</tbody>[/TABLE]


Basically, I need to group the whole data and separate those with Status note:
Upper Part: "Done", "OK", "Complete"
Bottom Part: "Pending", "Incomplete" and Blank cell

I need to do the same process on 5 more sheets (Sheet2-Sheet6). Note that the range may vary so need to highlight the whole row in separating data and sorted in descending order.

Any help will be much appreciated.