Excel Barcode Matching & Data Extraction -- 2

I have a workbook with multiple sheets, each sheet is from a supplier and has 3 columns, barcode, stockcode and product description. Each week I get a list of barcodes of items that need reordering - I want to paste that list into a worksheet and for excel to find the matching barcode by searching all the sheets (20+) then in the new owrksheet i want it to paste the contents from the matching cells in B C and D itno the new workbook - example below