Sorting with merged cells

[kmjones]

I have many many columns and rows. They are organized in such a way that there is 5 or 6 rows merged in the first column almost like a label. The following columns contain the unmerged rows and are like a breakdown of information about the 1st column's merged "label" If that makes sense! I would like to alphabetically sort these rows by the merged label while keeping the other columns that are a breakdown of that label with them. If you can help at all!!! PLEASEEEE let me know! thanks so much!

ie:

1 hot supply
Label 4 red converter
3 cold produce


3 blue supply
Label2 6 hot supply
5 green red
8 pink blue


I want to sort the "labels" alphabetically while still keeping the information in the following columns with that specific "label"

thanks!

 

[kmjones]

Book1
	A	B	C	D
1	Ant/Spkr	15	15
2	Audio	10	10
3	Back	25	25
4	Base	5	5
Sheet2

I would like the information in the first clip to be sorted and finally end up like the second clip on a second worksheet. I was thinking something along the lines of sorting column H for a yellow cell, if yellow copy and paste it. But, the trick will be to keep the corresponding row with the corresponding topic (name is in column A). I don't know if this is possible. Can anyone help?