I have a sheet that has a header(A1) that is a reference from another sheet.
Below this header(A2-Axxx) is data, values only, that correspond with A1, but are not linked. They are hand keyed.

My problem, is that the headers need to be rearranged, but the way things are now, the data won't follow the header when the cells are cut, inserted,etc. Is there a way to 'Lock' the data range to the reference cell? TIA
Paul