VBA to split report according to segmentation of rows unique values to sheet check

Dear experts

i have set of range data along with end of splitting values column AA

where values is unique rows get split as different segment header in sheet check

like under column AA no 27 where as text value is split rows data under corresponding segment values header

every segment of splited rows above FY-16 Business Entity Report for the & splitunique value collection,dispute,dues....etc

find the attachment