How to sort corresponding cell data in a worksheet when cell reference is used?

Hi

I have for example 3 worksheets in a workbook. I attached a simple workbook to illustrate the problem, and will later need to expand into a more complicated list in another workbook.

1) Sales (columns are: Category, Name, SKU, Units Sold, Sales Revenue. The first three column linked to the columns in "Inventory")

2) Cost (columns are: Category, Name, SKU, Cost of Each. The first three column linked to the columns in "Inventory")

2) Inventory (columns are: Category, Name, SKU)

When i do a sort in "Inventory"'s Name, the sequence of values display in other 2 worksheets will automatic update (which is ok).

However, the other independent values that are entered in columns "Units Sold", "Sales Revenue", "Cost of Each" is not automatically sort according to the new sort in "Inventory".

How do I make Worksheet Sales and Cost ("Units Sold", "Sales Revenue", "Cost of Each" )values sort accordingly to the "Name" when "Name" is sorted in "Inventory"?

Thanks.