Auto sort columns on opening

http://www.excelforum.com/excel-prog...book-open.html

I too am very new to the whole VB thing so please be patient. Like Stacy above, I too would like to have a column sort automatically on opening as well as the corresponding information in the parallel columns. Can you please help me with this?
Column A has a student's name, Column B the surname and Column C the student's House. The secretary adds new kids to the list (at the bottom) and I'd like the list to update by House so that all the kids in Haxell house come first, then all the kids in Jackson house and so on

Thanks a million for your help, in anticipation.

Wereman