To explain further:
In my 5 excel files, I only need columns
C8
D8
H34-69
M34-69
N34-69
F34
G34
P34-69
S34-69
T34-69

I want to take these columns and paste them in columns A-J