Combobox.value reference

[Freddy]

Hi people,

Summary:

4 worksheets
sheet 1 = 2 comboboxes
sheet 2 = list of people
sheet 3 = list of projects
sheet 4 = summary of people and their projects

Combobox1 = list of the staff surnames (Column C - Sheet 2)
Combobox2 = list of projects (Column C - Sheet 3)

I am trying to write some code that will take the value selected from
combobox1 and select the row of data (Column B:F) where that value came from
in sheet 2 and paste it into A1 of sheet 4

and the same for combobox2 but for projects and to paste it after the staff
details in sheet 4 (Example sheet4: staff details A : D, project details E :
H)

Thanks again for your help