Consolidate info from 3 fields in multiple workbooks into 1 seperate workbook

I need help in creating a formula/macro that will pull certain information from multiple workbooks into one sepearte worksheet. Attached are 2 documents to use as reference.

1. The final worksheet will be generated by using the "Cheapest Vendor vs. Cheapest Approved Vendor" field (Please note this field may be in a different column from workbook to workbook). Any item that is greater than 0% is what needs to be extracted.

2. Along with this the part number and description will also need to be extracted (these will always be in column A & B in the worksheets).

If you need to call me to further explain please feel free to call me at 513-252-4067 (Ryan).

Any help would be greatly appreciated.

bump................................

bump..................