Hi there,

In my workbook there is a front sheet, called 'September 2012-2013'

In addition to this there are several other sheets time schedules for a list of about 60 people. Each sheet is named with the date of issue, so for example '28.09.2012', '19.10.2012' etc etc
What I want to be able to do is lookup in the individual time schedule sheets on a row starting with a particular given name, and return the values to the Main Front Sheet.

This I can do, however what I have been struggling with is trying to use a function that will allow the particular sheet in question being looked up, to be determined by the contents of a particular cell in the 'September 2012-2013' Sheet.

Ive tried all combinations of (V)LOOKUP, INDIRECT, MATCH, ADDRESS, but so far i havent found the right combination.

For example, in the 'September 2012-2013' Sheet, in cell AG8, i want to display the value found by the lookup of string 'OLARIS, HOMIS', in column 5 on sheet 'X' (e.g. 19.10.2012), except 19.10.2012 is text in a cell in the 'September 2012-2013' sheet.

Does that make sense?
Any help would be hugely appreciated