It's a LOT easier if you could put all the source fund names in one column - say C, and values in D. IS that a possibility?
Do I get you right: you will select a portfolio for study in column A, and the rest of the sheet provides reference data listing all the funds you know and their current(?) value / what you have invested in them / whatever. You then want to run the macro and it will hunt through the reference material and assign values from it to the corresponding funds in A. These values will go into B.
If you do have to use several columns for reference, so long as there are no duplicate values you could use a simple but ugly series of SUMIF formulae:
in cell B3: