Formulas - data from one worsheet to another

[MJSOZ]

Hi all,


Thank you in advance......I'm attaching a mock up of a simple staff training register that I'm trying to do (the formatting/drop downs etc i'll worry about later!!). I'm needing the info that is entered into the Register (green tab) in the highlighted columns, to be transferred onto the summary sheet (yellow tab), under the corresponding staff number and category. I'm sure a combination of IF and LOOKUP would be the way to go, but I just can't work out the correct function strings Appreciate any help.......thanx