Reporting using data

Hello All,

I wondered if anybody could point me in the right direction with this.

I have attached a copy of a training log which we use to record who has been on what training.

On a weekly basis the trainers submit a report which gives details of who they have trained, the store their from and which course they have attended. This information is then taken and added to the training log, but when you have had hundreds of staff attend training it can be a long and painful process.

Is there anyway of the information from the weekly report being used to mark that the employee has attended the course. The report is on the tab named "training 08-09", each employee can be identified by their employee code and each store is under a seperate tab.

Many thanks