Iterative Macro that outputs a report after every cycle.

[tduvall]

I am trying to create a macro that will take the source data and remove the duplicates and then put them on a report. The macro will then take the duplicate list and search that list and put them on separate sheet or report, until there are no duplicates left. I basically want the attached in a clear workflow. Any better ideas would be appreciated. Thanks!

[Qiu]

@tduvall 
It will be much easier for us to unstand your intention if you can provide a sample input and output. 

[tduvall]

I have attached a sample data source that I am trying to sort through this method. Thank you for taking a look!