Hi,
I am not sure whether it is possible or not. I will try to explain my
situation.
There are 10 guys in the team and we have 10 sheets created in a work book
and all are of same standard format. I have named the sheets with name of the
person.

Now What I need is: I will have a main sheet lets say 'Summary' and one cell
will have drop down list with name of persons in the team. When I select the
name of person, automatically other cells should get filled up with the
details from the spreadsheet related to that person. Hope I am able to
explain clearly.

Ex: Summary sheet and Tim, Rob, John, Nancy are the sheets in the workbook
and all are of same standard format. In summary sheet in a cell if I enter
the TIM, remaining cells should take up the values from TIM spreadsheet. How
can I do that? Will lookup function for this?
Please help me out..