Function to extract a list of data from another list of data

As the title reads, I am trying to extract a list of data from another list of data that meets specific criteria.

For instance, the "original data" may have 100 lines of data with the following columns - "Name" "Date" "Action" "Comment" "Status".
On a different sheet, I want to show the (1) most recent 10 data that (2) has Name "ABC" and (3) Status is "Done".

I thought I had this working by using
{=LARGE(IF('Sheet1'!$A$2:$A$500=$E$3,IF('Sheet 1'!$H$2:$H$500="Done",'Sheet 1'!$F$2:$F$500)),11-ROW(A1))} for "Date"
and
{=INDEX('Sheet 1'!B$2:B$500,MATCH($E$2&$F25,'Sheet 1'!$A$2:$A$500&'Sheet 1'!$F$2:$F$500,0))}

However, I realized that when there are more than one same values for "Date", the second formula does not work. Please refer to the attachment (highlighted parts).

I'm thinking I need a different approach to this. I would appreciate any suggestions.

Thanks!

Sorry for the lack of explanation.

The raw data is on sheet "Recruiting Tasks".

On sheet "Partner Overview" under section named "Recent Recruiting Activities", I want to show the 8 most recent "activities" completed for partner on E3, which is Partner A.

What I have done is to search for all the "Plan Dates" in the raw data ("Recruiting Tasks") for Partner A that are marked as "completed" (column H in "Recruiting Tasks" sheet). Then used INDEX and MATCH functions to fill in the rest of the fields that match this plan date. However, when there are 2 identical plan dates, I realized the other fields do not recognize that this is a different data set and shows the same information.

On Row 25 ("Partner Overview"), it SHOULD be "E-mail", "Comment 4", "Kobayashi", "Team A", "2012/9/16" and "2012/9/20" (refer to Row 6 of "Recruiting Tasks"). However, it is showing the data from row above, because it has the same plan date.

Thanks for your help.

Thank you so much for your help, and sorry for the late response. The formulas you suggested does wonders for my workbook.

One additional question - how would I modify this if I were to adopt this to a sheet where the raw data sheet columns are different to the output sheet?

That is, currently I have Action / Details / Performed by / Team / Plan Date / Comp. Date / Status on both the raw data sheet and output sheet. However, if the raw data sheet had, for example, 40 columns and I only want to extract the Action / Details / Performed by / Team / Play Date / Comp. Date / Status, how would I modify this formula?

Thank you so much for your help.

Hello, I've tried using the forumla you suggested on the attached file.

The idea is the same as the Excel worksheet you helped me with, however the difference is that the raw data sheet has a lot more columns (Sheet "Data"). I tried creating a new sheet "Data_Sorted" to only pick up the columns that I need, then used your formula into the "Output" sheet.

The "Output" sheet is supposed to do the exact same thing as the previous file you helped me with, but the difference is that I want it to extract the data that has Comp. Date between the two dates specified on this sheet (F1 and F3). I tried forgetting about this new requirement first to see if your formula works as it is, and it's not working for me. I was wondering if you could help.

Thanks!