Reformat data in specific way using filter and split to two groups

Hello everyone
I have two sheets .. the first is for raw data which is needed to be formatted in specific way
Sheet2 is the result sheet .. I will explain what is fixed and what is to be changed

In sheet2, the cell M2 I will put a value from sheet1 column D (Here's as example 1 or 2) suppose I type 1 in M2

The headers from rows (5 : 10) to be copied again but there after the first group data with five rows (five blank rows in between the two groups)
As for headers the colored cells will be changed :
** J5 & J26 will be the same value as M2
** K5 will be the string "A's Group" & K26 will be the string "B's Group"
** L5 & L26 will have the total of results (as explained in the attachment)

As for the data it will not be exactly as the raw data .. notice the columns positions
and as for the column A in sheet 1 is just numbering and in the result sheet I need to number filtered data

NB : The data would be put after the header but let blank row as illustrated

Hope it is clear and easy
Thanks advanced for help

If I understand the request correctly the most obvious and elegant way is with a Pivot Table and a couple of Slicers to allow you to filter the results.

See attached.

Thank you very much for replies
In fact I need complex formats that pivot table will not satisfy me .. although pivot tables are great means
I have to explain again (I am sorry for not good clarification)
I will attach the file again putting sheet2 as it is and I need the output to be as illustrated before

001.png

Thanks Mr. Jindon for great solutions. You are very helpful
As for the headers in rows 26 : 31 would be a copy of rows 5 : 10
and the data will be dynamic in Sheet1 so the copied rows would be placed in another location (I mean rows 26 : 31 will not be always for headers .. this is just for illustration)

Simply : The code would grab data according to M2 and change the three cells in the main header (5:10) then put the data for group A class (M2.value) then five blank rows then the headers copied again and change the three cells

Please have a look at the sample in Post #4 .. That's a sheet (RAW Sheet) >> Please, Now I need the code to do all the task in the sequence of logic illustrated

That's all .. Hope it is clear
Thanks advanced for great and wonderful help

Thank you very very much mr. Sanram
That's exactly what I need .. You are great
And thanks a lot to Mr. Jindon (It is my fault of not clarifying my request well)

@Sanram
I just need to keep the rows 5:10 as it is and to use these rows as a copy (hope it is clear) then to change the values of the three cells in these headers
I noticed if I type 1 (it is ok) then if cleared the contents of M2 these rows cleared completely ( I don't need to hardcode the formatting of these rows .. just deal with these rows as they are)
Thank you very much
Best regards

Thank you very much for great help Mr. Sanram
I tested the code and typed 1 in M2 and everything is ok
Typed 2 and everything is ok
Cleared the cell M2 and everything as expected
But when typed 3 (or cleared the cell again when it is empty) .. I encountered an error 1004 at this line

Please Login or Register  to view this content.

As for the code I don't need to format the rows for B's group as I noticed that part of code

Please Login or Register  to view this content.

Rows for Group B would be just copy of main header rows ... and some changes in the cells that I refer to ..
Sorry for disturbing you ..

@Sanram
The solution is very great and working well .. Just need some modification to get rid of errors if any other value typed in M2 .. and depend on the main rows (as a copy for the second group)

Use this :

Please Login or Register  to view this content.

Thank you very very much for this awesome solution
It is working exactly as I need
Best and kind regards