Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

In excel 2007. I have multiple sheets. In those sheet i have in a2, a3, a4 up to a13 column student name.
In column B1 to AF1 i have dates. This structure in all sheet is same. column B2 : AF13 i enter data.

Now in summary sheet i have pull those data with specific student name & date. (structure is same as per other all sheet)
I define all sheet name as : listsheet
Please note student name from a2:a13 (vertical) & date from b1:af13 (horizontal)
I am trying below formula, but i can't pull specific data from multiple sheet with two criteria (student name & date is criteria)
=VLOOKUP($A2,INDIRECT("'"&INDEX(LISTSHEET,MATCH(1,--(COUNTIF(INDIRECT("'"&LISTSHEET&"'!$A$1:$AF$13"),$A2)>0),0))&"'!$A$1:$AF$13"),{2,3},FALSE)

I think it would be easier to offer suggestions if you upload a small (clean) sample of what you are working with, and show samples what your expected outcome would look like.

Thanks

You may need to adjust the ranges here, but it looks like you only have 13 rows? Use this, copied down and across...

=INDEX(INDIRECT("'"&TEXT(B$1,"MMMYY")&"'!$B$2:$AF$13"),MATCH($A2,INDIRECT("'"&TEXT(B$1,"MMMYY")&"'!$A$2:$A$13"),0),MATCH(B$1,INDIRECT("'"&TEXT(B$1,"MMMYY")&"'!$B$1:$AF$1"),0))

Great job, Ford!! I'm saving this one!

Regards,
Dave

Edit: Oh yes, thanks for posting this one.

Flame, thanks for the kind words and the feedback

Reps from members not even involved in the thread are especially appreciated

(Its really not as fancy as it looks though )

@ avk, not a problem - we are all in different time zones, Im just happy we were able to resolve your question for you, and thanks for the feedback