Unstable Data in Cells copying Downloaded Data

Hi: My Stock spreadsheet utilizes a Yahoo Stock data downloader. That VBA code then separates what is basically conconacated data into separate fields using a macro sub called TextToData.
This takes place at the far right hand side of the sheet in cells AAA:AAG.


I have selectively copied this data into the far left side of the sheet using the following formula in each cell that I want to populate. (=AAB3)

The problem I have encountered is if any cells anywhere on my sheet become shifted, all of this data disappears and #REF replaces it.

The Question is this: How can I populate those cells with the desired data and make sure that it remains stable and not volatile?

Should I be using =SUM(AAB3)?

or would =($AAB$3) make it more stable?

Thanks Michael