Transpose data from column to row using links

Question

I have some data in a row, say A1 to Z1, and I would like to link this data in another table. However, I would like to migrate it so that the data works from A1 to A26. It is important that it is connected in some function, therefore, if I change the data on the first sheet, the second sheet is also updated.

I am thinking of some formula that states that as you go through the cell in column A, she knows how to capture data from the next cell on the right in row 1. So: A2 = B1; A3 = C1; A4 = D1 ...

Any ideas?