Split Data from one sheet into multiple sheets

Hello! I am new to macro's and was wondering if someone could help me. 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 company name to the next company name. For instance, in the spreadsheet company name is Paper Inc. I want to grab that name and all the information below it until you hit the next Paper Inc. name, which then I want to take it and paste it into another sheet in the same workbook. Please let me know if there is something that can be done. I have written a macro for this, but it runs into errors, so I am looking for a fresh clean start. Thank you! PaperInc_Macro.xlsx

Thank you very much! This works perfectly!

jstewart22,

Glad that it worked. When you get a chance, please kindly help me out by doing the following:

[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Thank you, and have a great weekend.