Is there a simple way to Autosort a specific area on a work sheet.

E.G.

Column A Column B Column C
1) Salesman Items Sold Total $ Sales
2) Joe 3 $5000.00
3) Tony 2 $2500.00
4) Sal 1 $1400.00

These numbers are actually imported from different worksheets and databases,
so I'd like to sort from the existing sheet from High to Low based on top $
sales.

Can anyone shed some light please.