Amendment in code required to populate new sheets with colour

Hi all gurus!
I have explained the problem in attached sheet. Please see the and amend the code to accommodate new entries.

Regards.

PING!!!
Here is the code which works behind the scenes to populate sheets with colours.
I just need a little amendment in this code to adjust newly added column and associated two sheets (mentioned in detail in attached file).

Please Login or Register  to view this content.

PING!!!
Here is the code which works behind the scenes to populate sheets with colours.
I just need a little amendment in this code to adjust newly added column and associated two sheets (mentioned in detail in attached file).

Please Login or Register  to view this content.