Is Index/Match the proper formula for this?

Hello All,

I've been racking my brain on this problem for days now and I think it's time for me to ask for help. I have two sheets in a book which has the same fields and need to find a way to do the following:

Let's say Sheet 1 is your storm door
Sheet 2 is your front door.

Every day for the past 10 days Sarah has been going through Sheet 1 and Sheet 2 at least once a day. The issue I'm having is that whenever I try to pull data using Index/Match, it will only pull the first instance of the day, omitting the subsequent entrances. Is there any way to pull data from Sheet 2 into Sheet 1 within X minutes from each other and match the person doing so? Reason why I can't use Sheet 2 to do the same is because sometimes Sarah will go through the storm door but change their mind and not go through the front door. (The use is different, but the effect is the same).

Sheet 1 Contents:
Date, Time, (Date & Time Combined), Name
1/1/18, 00:01, 1/1/18 00:01, Sarah
1/1/18, 01:01, 1/1/18 01:01, Sarah
1/2/18, 12:01, 1/2/18 12:01, Neil
1/2/18, 12:02, 1/2/18 12:02, Sarah
1/2/18, 14:01, 1/2/18 14:01, Sarah
1/2/18, 14:06, 1/2/18 14:06, Neil

Sheet 2 Contents:
Date, Time, (Date & Time Combined), Name
1/1/18, 00:02, 1/1/18 00:02, Sarah
1/1/18, 01:02, 1/1/18 01:02, Sarah
1/2/18, 12:02, 1/2/18 12:02, Neil
1/2/18, 12:03, 1/2/18 12:03, Sarah
1/2/18, 14:03, 1/2/18 14:03, Sarah

I intentionally omitted an entry to Sheet 2 for Neil on the second go-around as I'm going to put in an IFERROR to kick out any "violations", but need help figuring out the rest. The actual sheet has over 218,000 entries on Sheet 1 and 150,000 entries on Sheet 2, and no one can enter Sheet 2 without entering Sheet 1...

I really hope I'm explaining this properly...

Please help!

Hi All,

I'm hoping that I was able to upload the file successfully. Thanks again for allowing me to brainstorm with you.

This is awesome! Thank you so much for your help.

Good Afternoon and Happy Holidays everyone!

Thanks again for your help JeteMC. For my own sanity though I was hoping to see if anyone would be able to help explain as to why this formula (set as an array, plugged into the "Storm Door" sheet, Cell E2) works similar to the response that JeteMc has provided, however isn't as accurate and takes forever to calculate??

=IFERROR(INDEX(TEXT('Front Door'!$A:$A,"MM/DD/YYYY")&" "&TEXT('Front Door'!$B:$B,"hh:mm:ss"),MATCH($C2&1,'Front Door'!$C:$C&IF(D2<='Front Door'!$D:$D,IF($D2>=($D2+(5/1440)),1)),0)),"Did not enter nest")

Thanks again for the Aggregate solution; I have to look into how the Aggregate works as I can probably apply it to other workbooks I've been using Index/Match on and sparing myself the hours of processing. haha