assistance on paste special formats vba code

AB33

nearly on the right track, just at columns Q and row 8 shows a discrepancy on actual macro .
On the expected sheets results there are formula in the columns yellow and green cells , some format cells green and yellow has non contigious cells formulas .
my apology for this insight