A LoopToCopyColumnWithMatchingYearQuarter

Hi, all. I need help with following problem.
pls open the attachment, you will see a simple sample worksheet which shows the same contents but different format seperated by column i . I need a loop could help me check the whether the year and quarter are same, if they match, then copy the whole column's value to the other side. But after copy the data, i hope it could copy the address, so that when the database change, the coped part also could change without run the macro again.
Greatly appreciate any help! Thank you.