I'm looking to create a sub that will pull information from a
different sheet ("sheet2"), and sum it into a cell on "sheet1". Sheet
2 contains a list of product #'s in column B, and I want it to
basically act as a function "SUMIF", where it sums all the costs
(column F) associated with that product if that correct product code
is in column B.

I know I can do this via a function (SUMIF), but I'm trying to learn
VBA, and thought I might as well start now.

Thanks!