Copy Rows Containing Unique Identifier From Column Into Another Sheet

Hello,

Normally I am able to get a huge head start on my code and trouble shoot debugging using existing forums but this one is one I'm not sure where to start.

Sample.PNG

So based on the attached doc this is the goal. Using the Meta Current Creditor header, all unique current creditor rows should be copied to a new sheet. Ex. Rows 2,3,4 will be copied to Sheet 1, Row 5 will be copied to Sheet 2, Row 6 to Sheet 3, and rows 7-12 to Sheet 4. Important things to note is that this macro will be run on different sheets so the Meta Current Creditor will be in other columns not always M. Also the data contained in that Meta Current Creditor field will vary (it will not always be creditor 1-9 it can change each time so the macro should identify a unique value for each one and copy all rows containing that value.

The end goal is for each sheet that is generated from the original report to be automatically saved as individual workbooks but for now splitting the unique rows into separate sheets is the most important.

I apologize for having no code already prepared as I said normally I record the macro and tweak like a novice.
Any help getting me pointed in the right direction would be HUGE.

Thanks!

I think I have but I'm not sure if the excel doc has been attached. Its my first time posting to the forum