Copy colored cell automatically into other cell

[FvdF]

Dear forum users,

I want to create an excel sheet containing the pagination of a newspaper. This newspaper consists of multiple (8) editions that get change pages on the previous printed edition.
The printing order is as in the attached example.

HAA is printed first and then there are a number of change pages in IJC. These are given a color and those cells should be automatically colored in the second schedule.

I was able to make this with vba but should be able to do much simpler in my opinion.
This vba is not complete, I only made the HAA.

Grtz,
FvdF