Finding values and pasting in a different workbook

Hi all,

I have a "Codes" workbook that has multi sheets. Each sheet has barcodes, codes and prices. I usually recieve an invoice from my supplier that has items with codes. I need to find each barcode, code and price for each item in the invoice from the "Codes" Workbbok and copy it to a third workbook to print the labels, lets call it "label"

What is the best way of doing it?
Attached is a sample from Code file, Invoice file and label file.

Thanks for help.

I don't understand all you want to do but I would create only ONE workbook with all the informations in it.
Put all your codes on one sheet. If needed for the lost of multiples sheets, create a new column with the name of the sheets in it for each code.
When you receive an order, use your product code as a key and use VLOOKUP to get proper informations like description and cost.
I don't understand how you label sheet work so I have no suggestion about it.
With some more information, we could help you.
Pierre