Populate Combo box with Index/Match using horizontal headers

Hi,
I'm having a bit of difficulty in populating a desired list through the use of a combo box, I'm hoping someone here has he smarts to help me.
We have a training register to show the mandatory training required per position, I would like the user to select the position from the combo box & underneath the mandatory training for that position will appear.
Data is in a table, copied below (I can't upload here for some reason?). So in the combo box I have linked it to a vertical list of the positions, CEO, OPs Mgr etc, I can see them in the combo list. Ideally then if someone could help with a formula to index the position, find all the X's in that column & change the X's to the training in the course name column. I really hope this makes sense but if not please ask away!
So from example below if a user selects Chief Executive Officer in the combo box then underneath the combo box we should see Staff Safety Induction, General Construction Induction & nothing else.

Course Name Chief Executive Officer Operations Manager Office Manager
Staff Safety Induction X X X
General Construction Induction X X
Provide first aid (HLTAID003) O
Provide cardiopulmonary resuscitation O

Hi Norie,
Thanks for the reply.
So I have a combo box on the first sheet that lists all the positions, when a user selects a position from the list I would like the mandatory training for that position listed underneath.
So I though I would have to use an index/match formula but if you have a better solution absolutely I would be interested to try it.

Hi,
Sorry for any confusion, it is in the first line of my original thread that I wish it to be populated through a combo box.
GRARG05 Uploaded.xlsx
I have attached the file here, hopefully that should clear any confusion
So you see I have tried a few copied & pasted index formulas but it's too complicated for my current excel level.

Many thanks

Thank you so much, that looks perfect, I've just tried to plug it in & I'm getting an object error on the 'idx = ComboBox1.ListIndex'.
Would it have anything to do with I have the list names as GRATitles & that's not in the code anywhere? Maybe it doesn't need to be?
Maybe do I need to declare the ComboBox or anything ie Dim Combobox1 as...?

I put it directly into a new module in the workbook, changed it to the Combobox code, worked a treat, you're a genius!
Many thanks!!