merge TOTAL row for each sheet based on selected name from combobox on userform

Hi
in combobox1 will match name with column C across sheets . should merge amount for every TOTAL row for every sheet alone for th same name just PAID word in column E for each sheet alone.
textbox1= BUYING sheet
textbox2=SALE sheet
textbox3=REVERSING sheet
textbox4=VERTING sheet
textbox5=textbox1-textbox2-textbox3+textbox4
without forgetting number format "#,##0.00"
and if the name doesn't contain data in other sheet then will be one of textbox should show" - "
and I would fixing code in combobox1 to populate all of names across sheets without duplicates an empty.
example:
select CR-1000 from combobox1 and match with column C across sheet and then should merge for each sheet alone .
also should deal with big data almost 7000 rows for ach sheet.