Consolidating multiple worksheets of names without duplicates

Hi there, I hope you can help.

I have around 40 worksheets in one workbook which are all attendance lists from events, each different worksheet representing a different event. They contain names, contact details, and ticks to say if they attended that event or not. All information is in separate columns.

I need to consolidate all the names into one worksheet, without duplicates, and with a separate column for each event indicating whether they attended said event or not. So, there will be around 40 additional columns to the attendee details (name, contact etc). Also, the contact details for attendees that have been to more than one event need to be their most recent details, from the most recent event.

I am sure I can use IF and SEARCH functions, but its a bit beyond my knowledge of excel.

Any help is greatly appreciated. If I can supply any further details, I'd be more than happy to, as the above question is quite general.

Thanks for your swift reply. Will attack a sample workbook shortly.

Sample Event Workbook.xlsx

Please find attached a sample workbook. The original has over 40 event worksheets with hundreds of attendees, but this a boiled down version.

You can see that I need to consolidate everyone into the Master sheet with no duplicates and with their most recent contact details.

Please let me know if you need anything else.

If you are referring to the date in each event column, this is entered manually.

Apologies, I forgot to add this to the sample workbook.

Every worksheet with each different event is called "(country) (date)"

Based on the format of my existing spreadsheet, the worksheets in the sample workbook would be named:

12.09.13 Egypt
28.07.13 Morocco

This applies for all.