Vba to sort multiple columns as one list

Hello, I have searched everywhere, so it seems, and can't find the solution anywhere. I have created a list of movies that I own in an excel sheet (2007) and have it go down 50 rows in Column A before I continued the list in Columns B, C and D for now. I am trying to find a way to make the entire list sort instead of just the columns. I like to be able to see all of the titles on the page without scrolling down. When I add a new movie I would like to be able to add it to the end of the list and then sort it and have it go where it belongs no matter which column that may be. I am hoping this is possible. To make it even better, it would be ideal to have it automatically sort when I add a new title.