macro user form populate sheet

hey guys
i am new to this but i have just created my first macro for auto fill, forced save and printout, i thought i was ready for this with the little knowledge i have, but im NOT.

anyways i want to create a macro that inserts my clients details and site address into an already created database, i have created the userforms (3 of) these are wat i need to program into them if it makes sense
Untitled.jpg

also the sheet i am trying to automate i want to auto generate the quote no and also the date so i can remove them from the userforms. not so much the date but if i can i will.

also the sheet has our clients details in many feildsbook.jpg

i would like the client feild on userform 1 to be a combox and as i type to auto bring up matching entries but only as the initial name my last attempt the combox box listed all details individually, i think i explained the jist of it


any help would be greatley appreciated.

TIA for any replies

any further information needed i am happy to submit