Using Macro to put rows in multiple sheets in ascending order

hello,

I am looking to create a sheet that automatically updates itself in alphabetical order, when we enter any data.

here is the case:
- I've 30 secondary sheets and 1 master sheet
-----------------------------------------------------sheets detail-----------------------------
Master Sheet detail:

• master sheet's column A contains name from A3 to A100 (user can edit this column)
• Column B to to AM contains data corresponding to each name in column A

Secondary sheets detail:

• column A contains name from A3 to A100 which are linked to master's column A (means any change in Master sheets' column A will change this column).................. (user cannot edit this column)
• column B to I contains corresponding data and summary of these columns are reflected in master sheet's column B to AE (Rest of the columns of master sheet i.e from AF to AM is used for further calculations )

----------------------------------------------------------------------------------------------

I want that when user enters a new Name in master sheet and presses "Enter" then:-
Column A of master sheet should automatically arrange itself in ascending order, along with all the corresponding data in column B to AM
since secondary sheet's column A is also linked with master sheet, so they should also be updated along with their data in corresponding columns i.e B to I

thanks in advance