INDEX, MATCH & INDIRECT combined usage
Want to retrieve data based on a matching condition from a dynamic sheet reference.
say for eg

Sheet 1
======
Student Name | Subject | Marks
----------------------------------
Bill | English | ??
Bob |Maths | ??
Mak | Science |??

Bill (sheet2 name)
=============
Student Name | Section | Subject | Marks
-------------------------------------------
Bill | A | English | 90

Now let me know how can I use INDEX, MATCH & INDIRECT functions to retrieve value in column Marks in Sheet 1 C2. Say C2 in sheet 1 should display 90
Tried Vlookup & indirect in the following way did not worked out got #NA result
=VLOOKUP($A2,INDIRECT("'"&$B2&"'!A:K"),3,FALSE)