Populating Data from one Worksheet to another with conditions

[Ngerengere]

I have a data table on one worksheet.

Job Title<strike></strike><strike></strike>	Department	Course1	Course2	Course3
Bagging Supervisor<strike></strike>	Packhouse	Yes		Yes
Bin Filler<strike></strike>	Yard		Yes	Yes

<tbody>
</tbody>

Table above is an example of Data sheet but has much more data. Below is second sheet where I want data populated depending on what job position is selected. Department Training Course (Dropdown List of Positions)eg:Bagging Supervisor<strike></strike><strike></strike> Job Title (Will be linked from Drop Down)eg: Bagging Supervisor<strike></strike><strike></strike> Department Packhouse<strike></strike> Training Course (Populated from data sheet if a yes was found) Course1 (Populated from data sheet if a yes was found) Course3 <tbody> </tbody>
So at a guess need a loop to check for a yes in the job positions row when that job position is selected from dropdown box. and populate the training course name to second sheet as above.

<tbody>
</tbody>