Otto,

Thanks for responding. I have one workbook and each of my sales reps enter
information on his sheet. Can you tell me how to do this? That would be
great! Also, if I did have numerous workbooks, could I combine them into one
with a convenient drop-down box?

"Otto Moehrbach" wrote:

JK
I'm not sure what you have. Do you have numerous workbooks, one for
each sales rep, and you want to combine them all into one, or do you have
only one workbook and each sales rep inputs information to only his sheet?
What you say at the end can certainly be done, that is, click on a name in a
drop-down and that sheet displays. HTH Otto

"JK" wrote in message
...
Hello,

I was hoping someone could help me. I have a "master" template set up and
each of my sales reps goes in and fills out the required information. I
was
wondering if there was a way to "combine" all of them into the master, so
all
I would have to do to look through each persons sheet is click on a drop
down
box on the master sheet, click on the person's name, and all of their
information would come up. Any help will be appreciated. Thanks.

.