Look up formula or help

[Squallr]

Hi,

Looking for a bit of help with my shift rota spreadsheet. On the Schedule part of the sheet I choose the names of people doing the shifts and there hours are auto calculated on employee hours page.

However what im looking to do is have an auto look up on Shifts by name page where it looks to the schedule and pulls over the data to the corresponding name, ie shift and time.

I have attached a link to the spreadsheet to this threadhttp://bit.ly/mbSwuq any help is appreciated.

Thanks in adavance