You add bookmarks to where the information is going to go, then create a form that asks for customer name (drop down box, maybe), when chosen it enters the necessary information to the corresponding bookmarks!
Se
here for an example of adding data to bookmarks with VBA