I have the following data in sheet 1

Column A
1
2
3
4
5

I need to transpose the data of sheet 1 to sheet 2 but I need to retain the
cell references so that whenever there is a change of data in sheet 1, sheet
2 is automatically updated.

In sheet 2, i need to get the data like this

Column
A B C D E
1 2 3 4 5.


If any of u have an answer, please post the reply.