Okay, an update:

I'm not 100% certain how the VLOOKUP function works, so I'm not sure just what would need to go where. I guess the problem could stem from some of the text (as above) being like:

Item Alpha : 5 : [blank]
Item Beta : 7 : [blank]
Item Gamma: 14 : [blank]
12 Alpha : [blank]
3 Gamma : [blank]
4 Item B : [blank]
25 Item G : [blank]

Unless there's something I'm completely missing with VLOOKUP, I'm not certain just how it would work. I'm working on getting the names to be more uniform; the names are all in Column A, quantities in column B, with the formulae for multiplication from the other sheet in columns D-K. On the other sheet, names are in column A, with the amounts being pulled to the other sheet in columns B-I (B to D, C to E, and so forth). One thought I had that could possibly make this easier:

Can I copy/paste formulas that only one part changes? Example:

=B4*$Page 2.B17 [copy]
=B4*$Page 2.C17 [when pasted to the next column over]

as opposed to what currently happens:

=B4*$Page 2.B17 [copy]
=C4*$Page 2.C17 [when pasted to the next column over]

Is this even possible, or just something I'm overlooking?