Reference Data in a row based on data in a cell

[DraconR]

Hi, sorry about the title but I cant really explain this one in one sentence.
I have one workbook, in it are 3 worksheets containing training record data for each employee.
Each employee has their own row and each column is designated for a particular training record, there are 3 sheets as there are 3 types of record data that need recording.
Anyway, I have created an additional sheet for each individual with a list of main quals that need more attention than the rest, this data is one sheet, I want to be able to create a sheet for an individual without typing in the data references to other sheets.

So in the new sheet, you select the persons name in the drop down list at the top and the data in the below cells fills itself in based on the persons name you selected.

Ideas?
Thanks peeps.

[Pepe Le Mokko]

Perhaps VLOOKUP or INDEX/MATCH combination? Adding a sample sheet would help

[DraconR]

Perhaps VLOOKUP or INDEX/MATCH combination? Adding a sample sheet would help

Thanks for your reply. I have attached a modified version of the spread sheet.
The 'personnel sheet' needs to reference data in the other 2 sheets.

[DraconR]

Thanks for your reply. I have attached a modified version of the spread sheet.
The 'personnel sheet' needs to reference data in the other 2 sheets.

Sorry forgot to attach.Training Record Matrix.xls