Hello there!

I've been trying to find a code that creates a new sheet at each change in data in a special column, but I can't seem to find any that works for my sheet.


Sheets:
(1)Colors(2)Blue(3)Green(4)Red

A Blue A Blue A Green A Red
B Blue B Blue B Green B Red
C Blue C Blue C Green C Red
D Green
E Green
F Green
G Red
H Red
I Red

I want it to be like this. The new sheets should be named after the data in the column as well. Hope this is possible to fix.

Thank you in advance!