Combined lookups

[sarah04]

Hi! I need some help with a lookup. I have one sheet where data is entered weekly, here:

Excel Workbook
	A	B	C	D	E	F
8	Entry Sheet
9	#	Name	Team	Total (by employee)	1/1/2011	2/2/2011
10		Total Hours		0	0	0
11	1	Angie	Uno	0	0	0
12			Area	Hours
13			1	0	0	0
14			2	0	0	0
15			3	0	0	0
16			4	0	0	0
17			5	0	0	0
18			6	0	0	0
19			7	0	0	0
20			8	0	0	0
21	2	Bill	Dos	0	0	0
22			Area	Hours
23			1	0	0	0
24			2	0	0	0
25			3	0	0	0
26			4	0	0	0
27			5	0	0	0
28			6	0	0	0
29			7	0	0	0
30			8	0	0	0
31
Sheet1

I need to lookup data from that sheet and insert it into the Area sheets, which look like this:

Excel Workbook
	A	B	C	D	E	F
1	Area 1 Sheet
2	#	Name	Team	Total (by employee)	1/1/2011	2/2/2011
3		Total Hours		0	0	0
4	1	Angie	Uno	0	0	0
5	2	Bill	Dos	0	0	0
6	3	Carol	Tres	0	0	0
7	4	Duke	Quatro	0	0	0
Sheet1

I thought maybe I could enter a vlookup by employee name, then an additional lookup to find the date and Area? I'm just not sure how to combine the correct lookups. Help?

I'm using Excel 2010.

Thank you!