Excel 2007 : Update Columns based on periodic data

Hi,
I have a sheet called MyHistory. Here I am archiving market information on hourly basis. This information is imported from some other sheet and comes to first column of MyHistory sheet (i.e. in A2A22). What I could not achieve is that whenever the market information is updated in first column, this hourly information gets populated automatically in subsequent columns i.e. First Hourly report in Column 2 (B2B22), next hourly report populates C2C22, then next D2D22, and so on so forth.

Could you please help me.

Regards.

Please help !

How do you get the original market information into Excel?

Is it through Get External Data and some external data source - web, text, database, or another Excel workbook?

First column containing original market information is linked with a set of cells from other sheets of same workbook.