excel user form
 

i have a user form wit combo boxes and text boxes. I have different
worksheets in the same workbook. i want data to be appended to different
worksheet tables from the same user form. how do i make this single user form
to enter data in relevant workbook. I have all workbook names in a combobox
in the form through which i can select a workbook. what would be VBA codes
for this.