Need macro to copy data from 1 sheet to multiple sheets based on certain criteria

I think I referenced the wrong row numbers in the last message I sent you (I may have been looking at a different version of the file). I've uploaded two filed here. "PCT download report_mod after macro has run" shows you what I got after I executed the macro. As you can see, I only see one line item from the data sheet per sheet generated. I also uploaded a "manual example of what macro should produce". In this workbook, I sorted the data by name, then pay end date, and then inserted two columns (A & B), where B puts the name and date together for a test name, and A decides whether the line item should go on the same sheet as the record before it, or a new sheet. In this care, there would be 12 sheets created, with 3 sets of line items (rows 14 & 15, rows 21 & 22, and 23 & 24) would be on sheets 4, 10 & 11, respectively. I created all the sheets, but didn't worry about having the correct data on the lower part of the sheets.
Please let me know if this information is helpful.

As far as the date is concerned... I am in the United States, and the date format I'm using is mm/dd/yyyy. I'm guessing you're using the European format which is dd/mm/yyyy maybe??? Maybe you see my dates in your format? But the format I've intended for everywhere on my worksheets is
dd/mm/yyyy. Hope that helps.... Thanks again.