Hello all,

I could really use the help of those much smarter than I.

I need to create a master list of items that are coming in from many other workbooks. These other workbooks are all in the same, terrible format (Not my fault it was made before I arrived), but I cannot do much to change that. I have attached the worksheet that I need to get the data from. I need to grab the Vendor, Contact, Contact telephone, Equipment, and Req'd Date when there is a Req'd Date (So if the Req'd Date is blank, it is not being ordered and as such should be left out entirely). I also need to get the address of either the site or the warehouse (listed at the top) based on the Delivered to Site or Warehouse column.

Then for each row that contains a req'd date, I need to paste the data above into the first unused line in a different workbook.

Any help would be much appreciated as I have no VBA experience and not the slightest clue where to begin.

Thanks,
Matt

I should also have mentioned that each of the workbooks coming in are originally the same, just blank, and then someone fills it out and sends it back. Therefore, a macro to export the data would be included in all of the incoming workbooks.