I have 3 spreadsheets that have lists of students' names on them, hours they've been tutored, etc.. I want to pull out the first and last names (which are in two separate columns) of all kids that have been in all 3 spreadsheets into a separate sheet. Is this kind of thing possible?

Thanks, Robert