I have 5 workbooks with multiple sheets in each workbook. To create the
report I need, all 5 workbooks and the worksheets within are referenced.
based on the values of particular cells in the main workbook, i need to
search the other workbooks/worksheets for instances of that value and
copy the corresponding row (or more specifically, particular fields
from that row) into a new workbook.

Example:
Workbook1.xls contains Worksheet1 that holds a productID,
productDescription, field3, field4, field5.

Workbook2.xls contains Worksheet2 that holds productID, productPrice,
field3, field4, field5

Workbook3.xls contains Worksheet3 that contains productID,
productInventory, field3, field4, field5

Now I want to Create a new Workbook that contains each productID and
the corresponding values from the other sheets.

Any examples or suggestions would be GREAT!!

Thanks!


--
tcgaines
------------------------------------------------------------------------
tcgaines's Profile: http://www.excelforum.com/member.php...o&userid=29608
View this thread: http://www.excelforum.com/showthread...hreadid=493089