Index Indirect macth

[namluke]

I have two tabs one named Leo and the other named Sasha. In these tabs I need to dump data on a daily basis.
I have an overview tab with formulas I highlight red… and to drop down boxes in A1 & A2
Im looking to bring back the data by using the drop down boxes in the overview tab.
I work’s until I change the name in the drop down.
Im pretty sure its because im using an INDIRECT within a 3way array lookup.
Is there a way to fix this?
Many Thanks
Luke

[RobertMika]

Leo has more tables than Sasha.
So when you change name and the Date range is outside Sasha's scope you will get #N/A error.