match data and bring them in one place between 2 spreadsheets

hi

i have name, pisno. fathers name and pf no. in sheet1 & name pis no. doa,dob,dos & sex in sheet 2 now i want name, pisno.,sex, fathers name, pf no.,doa,dob,dos in any of the sheet. Moreover not all data in sheet 1 and sheet 2 are same. only 40% may be same. for ex if person a is sheet 1 he may not be in sheet 2.in that case we have to leave them.