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:

First	x
Second		x
Fourth		x
Fifth			x

<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

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

First	x
Second		x
Third		x
Fourth			x
Fifth

<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

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

This is what I need the table to change to:

First	x
Second		x
Third
Fourth		x
Fifth			x

<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

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