Group and then sort these grouped rows of data:

[testtwo]

I wrote a macro to collect some data of other sheets in a totalsheet.
When the data of a sheet is collected in the totalsheet (for example 40shees with 10rows of collected data)
I want a macro to group and sort these rows in the totalsheet after writing this data.
• Grouping rows bij value in row A in given order:
1: "" (blank cell)
2: A
3: X
4: ? Any other value

• Then sorting these grouped rows bij number in colum B from low to high