【例】
Option Explicit
Sub 転記()
Dim I As Integer
Dim MotoSht As Object
Dim SakiSht As Object
Dim myRng As Variant
Dim MotoArray As Variant
Dim SakiRng As Range
Set MotoSht = Sheets("Sheet1")
Set SakiSht = Sheets("Sheet2")
MotoArray = Array("C3", "C5", "C6", "C7", "C8", "D8", "C9")
Set SakiRng = SakiSht.Range("A" & Rows.Count).End(xlUp).Offset(1)
I = 0
For Each myRng In MotoArray
SakiRng.Offset(, I) = MotoSht.Range(myRng)
I = I + 1
Next