Need to store a row of product names in alphabatical order in a new sheet and for this to be done automaticaly when a product name is inputed.

Any help much apreciated.

Thanks