Worksheet_change event on multiple target cells (if copy paste multiple cells)

Hello,

I need help with the following codes. I have 8 cells named "ChangeCell" and changing each one will trigger a different copy paste. It works now when changing one cell either manually or through copy & paste but I need this to be more flexible to allow the user to copy paste multiple cells at once (any number of cells within the ChangeCell range will trigger it and all of them need to be updated)

PHP Code: 

Private Sub Worksheet_Change(ByVal Target As Range)


If Not Application.Intersect(Target, Range("ChangeCell")) Is Nothing Then
      
         If Target.Address = "$AI$8" Then

         Range("AE9").Value = Target.Offset(, 1).Value
     
         End If
         If Target.Address = "$AI$9" Then
      
         Range("AE10").Value = Target.Offset(, 1).Value
        
              End If
         If Target.Address = "$AI$10" Then
      
         Range("AE15").Value = Target.Offset(, 1).Value
        
             End If
             
             If Target.Address = "$AI$16" Then
      
         Range("AE16").Value = Target.Offset(, 1).Value
        
             End If
         If Target.Address = "$AI$11" Then
    
         Range("AE8").Value = Target.Offset(, 1).Value
         
                  End If
         If Target.Address = "$AI$13" Then
      
         Range("AE17").Value = Target.Offset(, 1).Value
       
                     End If
         If Target.Address = "$AI$14" Then
       
         Range("AE19").Value = Target.Offset(, 1).Value
         
         End If
      If Target.Address = "$AI$15" Then
       
         Range("AE18").Value = Target.Offset(, 1).Value
         
End If
End If
 Application.EnableEvents = True
End Sub 


thanks!

ChangeCell - Sheet1 AI8 - AI16
This is part of a financial model where a user goes in to update actuals. I use Dec as the catch-all month to adjust for the difference between quarterly forecasts (ChangeCell) and the actuals. If the month is marked as A (Sheet2, row 10), grab actuals from Sheet1, if the month is marked as F, I set the returned value to be 0, just to be simple. in reality, if it is F, then grab values from forecast part of the model. the model needs to be adjusted when a quarterly forecast becomes available so current year always reflects the most updated quarterly forecast. I did it this way to avoid circular reference. The codes reside in sheet1. Please someone help me change the codes so that when a user copy paste into Changecell regardless of how many cells being pasted, the codes will do the same thing to every cell updated.

thanks so much!

Thanks so much for replying, I'm going to test it out. I tried to post a new thread under Formulas but I got a message saying posting is blocked. Can someone please let me know why?

attached is the popup...

Thanks so much!!

Hello just report back the codes work like a charm! thanks so much for your kind help Richard!!