Matching names, and inserting information between worksheets

Hi everyone.

SO I have a problem. I created a database in excel of all the previous attendees of our previous events spanning 8 different worksheets with a single overview sheet. Within these worksheets, the columns are first name, last name, email, job title, company.
I condensed these into a single overview spreadsheet (stupidly, manually), and to compound my misery only copied across the first name and last name columns.
I would now like to go back and grab the information associated with the first name and last name from the other worksheets, and place them in the overview sheet.

How can I go about doing this? I know I was stupid in the first place, so no need to point that out further, would appreciate anyones help.

Thank you!

Joe

This sounds like a job for VLOOKUP. It's hard to provide specifics for you without a sample workbook, but this link should get you started:

https://support.office.com/en-us/art...8-93a18ad188a1

If you're still having issues, try to post a small sample workbook (Use: Go Advanced > Manage Attachments) with all sensitive data altered or removed.