Using a drop down list to bring back data appropriate to the date selected

First of, new to the forum. I have been a lurker and was able to answer my own question pretty fast. I'm in the middle of trying to create a productivity tracker, and decided I finally need some more help.

Here goes...

I have a bunch of values for each each worklist by date. I'm trying to return those values to a summary page, by using a drop down box to change the date and those necessary fields populate, and also have a similar setup on an individual's work sheet.

I'm currently trying an hlookup and match combo forumla, but looks like it needs tweaking.

Any help would be appreciated!

Thanks,
Manny

Here's a sample:

Book2.xls

To pull the date into the 'Rachel' tab, the following formula should work:

=INDEX(data!$A$1:$M$47,MATCH(C$2,data!$A:$A,0),MATCH($A3,data!$1:$1,0))

Do you require help populating the 'Summary' tab from there? You could actually avoid using a tab for each person completely with the following formula in 'Summary' cell E5 instead:

=INDEX(data!$A$1:$M$47,MATCH(C$5,data!$A:$A,0),MATCH($B$1,data!$1:$1,0))

Thanks a million! I'll bypass the individual tabs altogether! You're a lifesaver!