Sorting a table with cell references

[aTmb405]

I am working with a table that I need to sort, while keeping the data in a row the same. Column A has an array function connected to a different sheet, and based off that sheet, column A can change. When this happens though, the other rows do not stay with the original data. Here's an example:

Let's say this is my table:
[TABLE="width: 260"]
<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 65"]First[/TD]
[TD="class: xl64, width: 65"]x[/TD]
[TD="class: xl64, width: 65"] [/TD]
[TD="class: xl64, width: 65"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Second[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Fourth[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Fifth[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

Data in Sheet 1 gets updated and so column A changes and this is what my table looks like now:

[TABLE="width: 260"]
<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 65"]First[/TD]
[TD="class: xl64, width: 65"]x[/TD]
[TD="class: xl64, width: 65"] [/TD]
[TD="class: xl64, width: 65"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Second[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Third[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Fourth[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[/TR]
[TR]
[TD="class: xl64"]Fifth[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]

(Notice the 'x' did not stay with 'Fourth' and 'Fifth')

This is what I need the table to change to:

[TABLE="width: 260"]
<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 65"]First[/TD]
[TD="class: xl64, width: 65"]x[/TD]
[TD="class: xl64, width: 65"] [/TD]
[TD="class: xl64, width: 65"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Second[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Third[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Fourth[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[TD="class: xl64"] [/TD]
[/TR]
[TR]
[TD="class: xl64"]Fifth[/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"] [/TD]
[TD="class: xl64"]x[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


Is there a way to do this within a table and keeping Column A's array formula?

 

[aTmb405]

Please provide any suggestions for how I can be more clear with my question.

 

[aTmb405]

Please let me know if this isn't a possibility, or if it's just really simple and I can figure out for myself

 

[aTmb405]

Should I change the title of the thread to gain traction?

 

[aTmb405]

Please help