Hey I need a little help...

Hey so I'm learning VBA right now and have realized how efficient it is, but i have a question regarding a project I'm working on. I currently have created a userform that uploads information placed in the textboxs in the next open cell . For instance, If excel hacks is in a textbox when i press submit it will send it to the next open column in the sheet.What I want to do is have the user form be able to read a name and depending on what name it reads send it to a specific sheet and also still document it in the overall summary sheet. IF that makes sense. Does anyone know how to do this?