Lookup with multiple sources

I have a spreadsheet that provides data to separate tabs (data comes from Access) , each tab has a unique name which is used as the identifier and contains data and a date. I tried using vlookup/match but the problem is that the raw data includes repeating dates for different identifiers.

What I need is something that can look for an identifier and a date. What match does now is it finds the first date it is looking for and stops, I need it to find the date associated with the identifier. (I hope this makes sense.)