Nesting IF & Lookup function to retrieve multiple values

Hello! So..I am having an issue creating this complex formula.


See Attached Spreadsheet.

The 1st Sheet (Employee) Lists all the Employee Data
The 2nd Sheet (Dependents) Lists all the Employee's Dependents data
The 3rd Sheet (Merge) is where certain data from both Sheet 1 and Sheet 2 need to go. Sheet 3's only purpose will be to export it's data to autofill pdf's (this part you can ignore).

The issue is that I need to pull Data from sheet 2 to fill in the information in Sheet 3 columns F-S. (Dependent information).

So ...what I need is for my formula to do this: VLOOKUP the employee name from Sheet Merge & Match it with The employee name from Sheet Dependents. If a match is found, then pull the dependent name, DOB, SSN, Relation, & Address and place it in the appropriate columns in Sheet Merge.

I do not know how to do this if the employee has multiple dependents. I also do not know how to make the formula put the spouse in the spouse column and the child in the child columns in Sheet Merge.

As I do not know if this is even possible, I hope an excel expert can help me out.

All I have thusfar is VLOOKUP(C2,Dependents!A:S,2,FALSE)