=INDIRECT("SHEET2!A"&COLUMN())横向拉动时,会对应Sheet2A列的行递增
在Sheet1的A1中输入“=sheet2!E1”,A2中输入“=sheet2!F1”,A3中输入“=sheet2!G1”