Excel Formula Help - Cross Referencing Two Spreadsheets

I'm looking to build a formula that will essentially get two spreadsheets in-sync.  Both spreadsheets contain vast entries/rows that have "Names", "Dates" & "Types".  I would like to build a formula ...