Alphabetically auto sort columns

Hi, I'm a new member.

I recently started using excel to manipulate data. I have created a few workbooks and I am working on a new one that I need some help with from the masters.

I own a service company and I would like to make a client contact list with the clients name, building address, cell number, office number, fax number and email address and how they relate to the building (eg superintendent or owner etc) each in a different column.

I need a macro that will take data in columns B-H starting at row 2 and auto sort it alphabetically when new entries are added after the row is completed. It needs to sort alphabetically by the data in column B and maintain all the other info in the row when it sorts.


Thanks in advance for all the help.