Copy cell range onto new tabs sorted in groups

[branston]

Hi

New to Excel VBA and hoping someone can help.

I am trying to copy a range of cells onto a new tab depending on the 'group value' in column H. The range is sorted in either 3,4,5,6 groups.

The columns and rows on the 'main1' sheet can change and that's where I am struggling. Group 4 needs to appear under Group 1 on the new tab but the rows can differ so potentially causing a overwrite?

I have placed on the 'sorted1' tab exactly how I want the data to appear (in the correct positions ie. cell positions) once the macro runs correctly. File attached.

Can anyone help?

Thanks