VBA to Sort Value in a range of cell for multiple Column

[Fatekb]

Hello and thank you in advance

i have three section that contain sporadic values, I'm struggling to have a VBA code that can sort and organize these value from top to bottom and from small to large under its own columns
and so there no blank cell in between values.
i have attached the example
kindly and very well appreciated.

[mjr veverka]

1. Should the sorting be done within each section separately or is all data to be moved to the top-one section ?
2. Do the sections have fixed sizes (at this moment: sec1 = 15 rows x 14 cols; sec2 = 19 rows x 14 cols; sec3 = 19 rows x 14 cols) ?

[Fatekb]

very good question , here is why !
1-sorting to be done within each section
2-these section has fixed sizes,
now i was planning to alter the vba code to make it fit into 6 other departments located on the same "sheet1" similar to Book3 example, that each has fixes row count, but varies in different column count.
thank you

[kvsrinivasamurthy]

Does each column in each section to be sorted Ascending separately?
Pl give the expected result of the given data in other sheet.

[Fatekb]

I have attached the whole sheet to be more helpful, and this sheet contains marcos and VBA functions might not work for you accordingly cause I did copy paste.
I do have a working macro to sort the header columns (small to large) than (left to right) in each section.
and that keeps the current values under its own column but not sorted from small to large, and top to bottom.

Thank you again for the follow up