Analyze a series of spreadsheets in excel, and present the results in excel or make a script in VBA

Analyze a series of spreadsheets in excel, and present the results in excel or make a script in VBA. Details: A company buys products in many countries. Then suppliers make one or more consignments with products purchased. Items are received in a warehouse and enter a IT system: PURCHASE: Worksheet 1: It has an excel spreadsheet with the following data: Column A: Part Numbers (Part Numbers of products purchased) Column B to Q: Name the suppliers countries Column A: Total "part numbers" Purchased (A product can be purchased in more than one country) Column S: Unit price of each product Column G: Subtotal (Unit Price multiplied by units purchased) The number of purchased part numbers are 4118. SHIPPING: Each country makes one or several shipments to complete the sale, so you can have one or more spreadsheets with the following data: Country: Country name makes shipping Shipping Number: Number of air guide. There are so many excel spreadsheets and airlines guide Each excel spreadsheet has the following information: Column A: Part Numbers Column B: Amount Sent RECEPTION: In Warehouse receive aerial guides and entered into a spreadsheet in excel product received and their quantities: The spreadsheet has the following information: Column A: Country that sends products Column B: Aerial guide Column C: Part Numbers Column D: Amount received physical Result: You want to get a list with the following results: By sending country products: 1 did a country to complete their sales. Should show numbers aerial guides. 2 List of part numbers purchased vs received part numbers where the difference is zero. That is, the same amount of part numbers received purchased. 3 List of part numbers received by country, with negative difference. It is received in stock less than the quantity purchased. 4 List of part numbers received by country, with a positive difference: That was received in the warehouse more than the quantity purchased. 5 List of part numbers received by the country that were not purchased. Shipping provider other part number, different purchased (In this case we have the price of this part number). For points 3 and 4 should show the difference in money.