creating excel form to update data sheet

the project is simple , i need to activate a form to update excel sheet using small macro , edit and add records to existing sheet ( two sheets : 2 Clients details & Contact log) I have an excel sheet including data for some clients who need to be update through a from the excel file includes 4 sheets: 1 input Form 2 Clients details 3 Contact log 4 drop lists the excel file is ready but i need someone to run the first sheet " input form " where i enter the customer number then the data populate from clients details then i update the fields then press " Update records then all the info i entered should post it the right place in "Clients details" sheet. also i want to update the contact log sheet from the same form the file is simple and the type of the fields is well explained , some fields are drop list,some is text or numeric entries. i need the Input Form to be friendly and easy to use , i would like to rebuild the form structure to be more easy and friendly i wanna have the ability to chose which client i want to update his records through : enter his customer number or through the drop list in the top of the form. some fields are including formula linked with an external excel file just ignore it