在Sheet2中提取Sheet1从A6开始的偶数行和A6,D6,M6,Y6这四列

SHEET1 A6开始的偶数行
=OFFSET(INDIRECT("Sheet1!"&"A"&(ROW(A6)*2-6)),,,1,99)右拉下拉

A6开始列 =INDEX(Sheet1!A:A,ROW(A6))
D6开始列 =INDEX(Sheet1!D:D,ROW(D6))
M6开始列 =INDEX(Sheet1!M:M,ROW(M6))
Y6开始列 =INDEX(Sheet1!Y:Y,ROW(Y6))