Is there a way to set a condition to automatically re-sort data as it changes
on a table?

Example:

I have 3 column:
A) Sales agents
B) Items Sold
C) Total Sales in Dollars

the data is being imported into those colums from various sites and
worksheets.
I'd like the 3 colums to automatically sort Hight to Low (Z toA) by Dollar
Amount (column C).

Any suggestions?