I have a workbook that I created in excel 2003, it has several worksheets
that require some of the same information in different cells. Can I create a
worksheet at the end of all the other worksheets that contain all the
information and create a drop down list (say using the name of the person) on
the other sheets to pull in the information needed in the columns required.
If more information is needed please let me know and I can supply.

Thanks chef mike