Lookup values across range of worksheets

Looking for some help please...

I have a workbook with a summary sheet that i want to lookup values across a range of worksheets against an individual employee (see attachment).

In the summary sheet when I enter an ID number into cell A2 I would like the values to be returned in A8 through to D8 from the values entered into each monthly worksheet (2011 Jan, 2011 Feb etc.)

So for example, for ID number 1 (entered into A2), lookup the value of Sat 01 Jan 11 in the worksheet that Sat 01 Jan 11 appears in against employee ID 1

Hope that makes sense?

Any ideas how to do this please?

Many thanks.

Anyone any ideas how I can achieve this please?

Many thanks.

try this formula is cell A8 of Summary:

=INDIRECT("'"&TEXT(A7,"YYYY MMM")&"'"&"!R"&MATCH($A$2,INDIRECT("'"&TEXT(A7,"YYYY MMM")&"'!$A:$A"),0)&"C"&MATCH(A7,INDIRECT("'"&TEXT(A7,"YYYY MMM")&"'!$1:$1"),0),FALSE)

and copy it across as required.

Excellent! That's just what I was after.

Many thanks firefly2k8