Combining 2 workbook to make another

[Brian]

To simplify my last question

I have 1 workbook that has cells with quantities and one
workbook that has costing for each item. I would like to
produce a 3rd workbook with the total cost of these 2
using the fill handle because I have over 100 quantities.

Thanks