Summerizing data
 

Hello again,

I have a file(BOM.xls) which has multiple diciplines work sheets. On each
work sheet is an area to put vendor quote data into to summize a quote
process. Vendors are the columns and part numbers are in rows. I want to
select all of the vendor forms (1.xls, 2.xls, 3.xls...) and extract their
data from the respected workbook and place their data into master file
(BOM.xls) in the respective column and rows based on the vendor who quoted
for me. I can send an example if need be.