Last dates from special range

[tulls]

Hi people.
I waste about 5 hours with this problem. I try functions as INDEX, MATCH, SMALL, etc. etc. etc. but unsuccessfully

I need sort a few last dates in column H from column B, but range are only cells with letter E in column E.

Please, please, please for your help! THANK YOU!!!!!!!

 

[PCL]

Did you ever try a Pivot Table

 

[tulls]

PCL, thanks for your quick reply!
I'm not sure, that Pivot table is right. But is possible that i wrong.

I have more sheets with more dates. And I want something as Client card, with last dates of communicate, phones, mails, etc. When I write name of firm in cell A1 , I want see all this dates from all sheets. I hope, that you understand me.

So, is Pivot table right solution? If yes, I like try it.

 

[AhoyNC]

Pivot table is the easy way, but here is a formula.

Formula below is an array formula and must be entered with CTRL-SHIFT-ENTER.
Copy down column as needed. Change ranges to match your data if needed.

=IFERROR(INDEX($B$2:$B$13,SMALL(IF($C$2:$C$13=$G$6,ROW($B$2:$B$13)-ROW($B$2)+1),ROWS($B$2:B2))),"")

 

[PCL]

Pivot table can work but if you want to review the data through several sheets it will be more difficult and certainly is needed a macro.
Does data always in the same column for each sheet?
What do you want to show when there is duplicate?

 

[tulls]

Thanks guys.
AhoyNC, thank you but this formula, isn't right for me. I know, my mistake, I didn't write that data aren't on same sheet.

PCL, thank you for your interest.

This is sheet1 with dates about orders

This is sheet2 with informations about client.

And I want all dates and infos on CLIENT CARD. It means something as easy CRM.
And to second question: If is duplicate, i need see all dates.

If is here some PREMIUM section, please let me know. I realize, that it is complicated, so I like something pay.