Split up different data sets in same columns into their own worksheets

Adam_Jones8221 

Adam, is it possible for you (without including any actual names of clients) to post a copy of the actual spreadsheet you get after this import into Excel? Post it on OneDrive or GoogleDrive and put a link here that would grant access to the file.

I'm asking that, so as to see the actual file. From the brief description you give, it might be that you'd be making your task more difficult by continuing to separate the data segments.....Excel can do some wonders when it comes to parsing data; it's often the case that people get in the way of letting Excel do the heavy lifting because it makes more sense to us as people to look at separate tables. But Excel, as I said, can take a single table and do lots.....   So let us see (if you are willing) what you're actually working with before you go, possibly, down a rabbit trail you needn't follow.