Confusion with referencing data and sorting

[gardengal444]

I'm scratching my head trying to see if this is doable and how.

I have 2 worksheets (of many) in this project. The following is a super simplified version of problem.

Sheet A is randomly sorted and is presented to the user as a logical grouping of ITEMs

ITEM COST AGE
apple 5,000 9
pear 1,000 2
chair 2,000 10
desk 500 2


Sheet B needs to present the AGEs and the COSTs In descending order of AGE. Sheet B does not need ITEM.

AGE COST
2 1,000
2 500
9 5,000
10 2,000

Ultimately, total costs will then be calculated for specific upcoming years.

I want to create SHEET B's values via FILL (way too many to do manually.) with SHEET B's columns linked to SHEET A so that if SheetA.COST gets updated, SHEET B will reflect the new cost automatically.

My attempt: "temporarily" sort SHEET A by AGE.

ITEM COST AGE
desk 500 2
pear 1000 2
apple 5,000 9
chair 2,000 10


create SheetB.A2 link to SHEET a (SheetA!C2, +). Then re-sort Sheet A back to its random order (I created an ordinal column to help me do that).
Problem: Sheet B loses it's sort order of AGE. I tried various usages of inserting "$".

Warning: novice level… kis
Excel 2007