userform help with code for combobox4

[s_g]

Hi

The Userform works perfectly but now I have just added Combobox4 to the userform.I never sent to 2 sheets with the single userform so not sure it is even possible....Currently all data is sent to either sheet Unit 1 or Unit 2 or Unit 3....what code do I need to add so that when a selection is made in Combobox4 it looks at both the Date,Unit and Shift and then sends this number to matching criteria....example...If the date in Userform is 7-1-2014,Unit A and Shift as Afternoon then it will send only Combobox4 to "Unit A Performance" C19 and the rest of data goes to sheet "Unit A"
..example...If the date in Userform is 7-1-2014,Unit C and Shift as Night then it will send only Combobox4 to "Unit C Performance" C35 and the rest of data goes to sheet "Unit C"

Thank you