VLOOKUP using multiple data sources

Hi Everyone,

Before I ask the question let me start by wishing everyone a happy festive season.

Now for the hard work :-)....

I am creating a document that requires the VLOOKUP formula to check multiple sheets to return the desired result. I'm going to try and give a basic layout of what I am looking for.

Sheet 1 - Results Sheet (Workbook A)
Sheet 2 - Data Sheet from a different workbook (Lets call it Workbook X)
Sheet 3 - Data Sheet from a different workbook (Also Workbook X)
Sheet 4 - Data Sheet from a different workbook (Also Workbook X)

Workbook A contains all staff list of all staff within the business across all departments on one worksheet.

Workbook X contains all staff within the business seperated onto different sheets per department. Each sheet has the staff memebers name in column 1, and then has a column for each week of the year.

I would like Workbook A to perform a VLOOKUP (Or whichever formula would be best suited) to look to Workbook X and return the scores from the various weeks onto one sheet in Workbook A.

I hope that this explination makes sense as it is rather difficult to explain what I am trying to achieve.

HI there,

I have uploaded the files to the following links:
http://www.4shared.com/file/8fGQn9Im/Wookbook_A.html
http://www.4shared.com/file/fennDKRa/Workbook_X.html

Sheets named Weekly are the data sources