Hi, I need some advice.

I have a list of 100 names in one column and to the right of that I
have several additional columns of data linked to those names.

I produce a one page report every week that contains selected names
from the list along with the other data linked to those names to the
right. I usually put the names inside a border box to dress up the
appearance. The size of the list varies from about 5 names to 20 at
most.

Is there a way I can automate this process say with a bunch of drop
down or combo boxes linked to the list in another spreasheet? I'm
getting tired of copying and pasting the names into the report every
week.

Thanks for any ideas you can offer.