I require a command button that will ask me to enter a 'client code' and 'client name', and insert this information in a new row. Client code will be shown in column a and client name shown in column b. I need this new row to be inserted in alphabetical order with other existing rows as well as copy the formulas and conditional formatting on all related cells within that inserted row.

On a another workbook I require the same as above, but with the addition of inserting the row on multiple worksheets.