Excel 2007 : Alphabetizing and combining

[Richie.rockwell]

I need some help with a workbook that i am working on that is basically a contact list. The workbook consists of 7 sheets that are all set up identically (excel 2007). Each sheet utilizes column A-M and each header is the same for each column across the workbook. Here is what I need to do (and unfortunately i cannot attach the data for help because the information is "sensitive") and, from what i have read, i will need to do this through"code." I have found several codes that have not worked or done what they i need them to do.

1.) When i put in a new company name (column A) i would like the informaiton that is input in the row to be alphabatized by company name.

For example- If i put in a contact from Wallgreens in row 32 i would like that entire row to be placed with the contacts from wallgreens.

2.) everytime a new company is input (column a) in any of the seven sheets, i would like it to populate on an 8th sheet to create a "Master" or "summary" sheet. I would also like this summary sheet to be alphabatized and include ALL information from the 7 other sheets int he workbook.

I have attached a sample workbook with out values to help in the code writing. I am not very excel literate but am trying to learn and am doing pretty well, this code stuff just throws me.

Thanks so much for your help.