Excel Look Up

I want to take 2 worksheets and be able to insert information regarding specific cells from one to the other. 1 worksheet has our inventory items listed and the Quantities used in a given time – the other worksheet has all the inventory item descriptions and data but does not include quantities. I want to be able to make worksheet that will include information regarding each line item and will have both worksheets information combined.