Split Data from one sheet into multiple sheets by recognizing a symbol (=)

Hello! In my office, we get a report from a website that comes to us in an Excel spreadsheet. We are looking to run a macro to split that data that is on that sheet into multiple sheets. I will attach a copy of the sheet to this thread. I am looking at grabbing all the information from the persons name to the next persons name. For instance, in the spreadsheet the persons name is John Doe. I want to grab that name and all the information below it until you hit the next persons name, which then I want to take it and paste it into another sheet in the same workbook. The only thing is that each report does not have the same names on it. The only thing that each report has in common is the ============= ============= in column B. Please let me know if there is something that can be done. Thank you!Name_Macro.xlsx

Thank you for the reply! This works. I have a couple of things that I am trying to do to the code that you provided. First, I would like to delete the First three Worksheets after the information has been copied. Second, I am trying to rename Sheet 4 & 5 to M_Report and N_Report. Is this doable?

I do not know how the code did not show an error on this line.

Please Login or Register  to view this content.

It did throw an error without the "t", but I noticed that and fixed it myself : )

After the deletion

I put your code into the macro and it does work the way that I want. I also added a piece of code near the end to make Sheet 4 and Sheet 5 rename:
Sheets("Sheet4").Name = "M_Report"
Sheets("Sheet5").Name = "N_Report"

This all works the way that I need it to! Thank you for your help and replies!