Excel VBA Append data from one cell to another

Please refer to the spreadsheet that is attached “GQ Spreadsheet.xlsx” when reading this problem statement.

Background...
The cells in row 3, the green fill color is RGB(153,255,51)
The cells in row 4, the yellow fill color is RGB(255,255,0)Note - In this screen shot the TEXT in the 1st green cell is
"GQ-005 - Approval Time"
and the next green cell has
"GQ-008 - GMP Certificate"

Process…
In the area BETWEEN the cells that have the green RGB(153,255,51), in this case Columns D to W...
I want to copy the value in column "E" (Not Applicable) to column "A"
Then copy the value in column "O" (3 Months) to column "A" (appended)

• Note that the column data that gets appended has the word "Regulatory" in the header with the yellow fill color.
• Note that there is a third occurrence of "Regulatory", the data in that column contains "3 Months" which has already been appended, there should be no duplicate data that gets appended.

Hopefully this is clear. If not please ask any questions you may have.
Thanks for your help in advance.GQ-Spreadsheet.xlsx

Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…