Multi functional macro- insert rows, copy data,adding

I have started recently to mess around with macros but I can't quite figure out how to do this one.

I have this list of songs with three columns (artist, title and track #) but what i want to do with it is to insert a row between each artist while dropping down the track #. But when the artist is the same i want to add these track numbers.
Attached is what i have and on sheet 2 is what I am trying to figure out if my explanation is not too clear.

Can anybody take a look at it.
Thanks a lot.
T.

Hi,

Your sheet 2 doesn't appear consistent. At least I can't follow the logic.

Where do you get the 5 for Bruno Mars on row 19?

Why do you show 8 for Chiddy Bang on rows 22 & 23, but not an 11 for Breaking Benjamin on rows 17 & 18?

Regards