Excel 2007 - Sorting
 

Is there a way to have excel automatically sort records by a specific column
automatically when data is updated.
Columns A to I 20 rows of data. Column A ranks the rows of data, want it to
auto sort the data, as I enter data in other worksheets

Any way to auto sort without having to continuously sort manually.