How can I find data in one list and add it to another sheet?

[soconfused]

I currently have two workbooks in which I need to have data from one
transfered to the other. One workbook contains many sheets and I need to
look in 4 sheets to find the information that I need. The workbook that I
need the data transferred to also has many sheets, but for the year we are
currently in, I only use one sheet.

How can I grab the data from the first workbook and transfer it in the
correct columns to the 2nd workbook.

Thanks in advance for any help you may be able to provide.

 

[soconfused]

I need it to fill in automatically when I input data into the first sheet.
The workbooks are completely different in the way they are setup. The one
common piece of data is the part number.

 

[Gary''s Student]

To automate the process you would need a macro. You would need to exactly
specify the source and destination columns and any logic that determines the
destination options. Here is a typical example:

http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/c98254c3ee4370ad#