Split data into separate Excel with one column, then to separate sheet with another column?

@billknguyen tried recently to illustrate how this works with a screenshot