Copy data and finding result from multiple workbooks into one

[p4ngp4ng]

Hi!I have 5 workbooks, each workbook contains multiple worksheets and different header.Worksheets Name:1. Bundle Input2. Rebundle3. Sales4. Warehouse Transfer5. OthersIn 5 workbooks, I input all bundles in and out everyday of every month. The difference of Sales workbook was, it has a column that indicates "Sold to" which in column B so other column will move.A1 to 3 -DateB1 to 3 - Bundle No.C1 to 3 - RemarksD1 - Item codeE2 - Item sizeF1 and G1 - AA (item code value)F1 and G1 - 2x3x10 (item size value)and so on...E3-PcsF3-Volume m3Can someone help me to have new workbook where I can input Item code or Size then it will automatically search for: ( that will separate local size to export size stock)Stock as of (date):Input Item code/size:Total No. of Local/Export Bundle stock:Total No. of Pcs:Total Volume(m3):But the value/data of 4 workbooks that will be inputted (rebundle, sales, warehouse transfer, others) must be deducted to total bundle input, but the data will not be deleted from bundle input.