Can I AutoSort without refreshing?
 

We have a friendly contest here at our office, each week we update sales, and
the one with the most sales during the week, everyone else buys them lunch
the next week. my question is; is there a way to automatically sort the table
that we use, without refreshing each time. Thank you.