Build a Excel VBA User Form for Order Entry by End Customers

Build a smart user form, in which customers can enter their orders. The form can be shared by me with multiple customers over email. and once they enter the order, each order is sent in an excel sheet back to me over email.