Userform search from sheet and find criteria and sum

Hello to all,

I really need help from you guys, i dont know how to use userform and VB, i can do everything with formulas but when the work comes to VB, i stuck.

Below print screen you can see my operation table, i can control some rates according to nights from days, formulas are working good, but i need a simple user form that shows below;

I have 4 sheets, for example svx,tjm,pee,cek. In userform i am at 5th sheet, 1st search can i select which sheet, if i write svx it will load svx dates for below date area, and when i select or write date does not matter, will give me cost plus 6 night 80 become total price.

I am just asking how it is possible to search in sheets and sum that given values.

EDBzsh2.png

Please help me,

thank you very much.

Really need help please...