I don't know if I can clearly explain what I want to accomplish because I am
not well versed in Excel terminology. But here is what I'm trying to do using
Excel 2000.

When I enter a data value into a cell (i.e a product code #) on my "active"
worksheet; I want Excel to look for that data value on any one of three other
worksheets (i.e products1, products2, products3) and have multiple cells on
the active worksheet automatically populated with product data from the
products worksheet that holds the data associated with the product code
entered.

My active worksheet is dynamic, in that it will receive a data entry value
of "product code" in any row but always within the same column.

The product worksheets from which I wish to retrieve data from are set up
with product code in column A and data related to the product are contained
on the same row as the product code but within multiple columns. (i.e price
in column B, description in column C, weight in column D, etc.)

If you understand what I have described God bless you and if you can show me
and easy way to do this in Excel God bless me.

I have a limited technical knowledge of both Access and Excel but I'm
inclined to believe that what I'm describing is something that should be done
using Access. I know more about Excel than I do about Access so I'm hoping
there is an easy way to do it in Excel.

Thank you for your indulgence, understanding and any help you can provide.

Thanks,
Dan