Linking rows to a column
 

I saw the post below about linking columns to rows, but am not smart enough
to adjust it to rows to columns. Example- Data in Sheet2, Rows A1-X1 need to
go to Sheet1, Columns A1-A26. I need to do this for about 24 sheets, so I am
too lazy to use the = function and manually input. Thanks in advance for the
help.