I am trying to make a formula that may need LOOKUP,INDEX and MATCH functions.

I am trying to make a formula that will look up peoples names and their relevant info. They are sorted into groups on sheet1 ,Named group 1 , group 2 ect. On sheet 2 when I enter the group name in cell C4 I need to have a formula list up the peoples relevant info like if they are male or female, Birthday and a few others as well.

Then on sheet3, I only want to enter a single persons name and have their data be brought up.

I have simplified the workbook, as there is a lot more info to enter other than birthdays ect, plus there are thousands of peoples data that has to be entered, so I need to be able to expand the lists ect as the list of people grow.

TIA.