Having such a database-like list, it is recommended to select the entire list (incl. column labels) and give a name to it: Call menu:Data>Define... <descriptive_name> [Add], [OK].
menu:Data>Sort... lets you choose up to 3 columns, for instance first order by surname, equal surnames by forname, equal names by zip-code. Take notice of the additional options on the second tab of the sort dialogue.
Now this sort order is stored for the named database range. After editing the range you can call menu:Data>Refresh in order to apply the same sort order again.
When adding new rows to the list, always insert new rows rather than appending them into the blank space below. This way the named reference expands to the new size as well as all other references, for instance SUM(A2:A99) becomes SUM(A2:A100) when you insert row.
Likewise you delete rows in order to shrink the list.
TheGurkha wrote:Click in the column you want to sort by, but don't highlight the column. Then sort. I just tried it and all rows in all columns moved accordingly, not just the column I decide to sort by.
This detects the currently used region and sorts all rows including a first row of column labels and possibly a trailing row of calculated results (sum of column).
The quick-sort method by button works well if you keep a blank, hidden row below the column labels and then click a single cell in the data range.