Macro for multiple vlookups over 1000's of files

[Nuns4President]

Hello,

I am needing to find the price of about 45000 units based on the PO number, and style number, and size. I have the price of these units in excel files, but there are probably close to 5000 files.

Would it be possible to create a macro to match these three values and return a price. Also, the excel files it would be looking in has multiple tabs on each one.

So, I need to look up the PO (C), style (E), and size(H) on the first tab (Ocean Inbound) under the folder "O:\Cost Basis\2011" and bring back the price (N).

Your help would be very appreciated if possible as I have no experience in creating macros.

Thanks