Data look-up and output from separate spreadsheets

[squire82]

Excel 2003.

I have attached an abbreviated sample spreadsheet of typical employee investment information we receive (the actual contains much more information). What I need is some form of code that will identify the value of a specified fund or funds across all employees. In reality there will be four funds that we are always looking to obtain the value of, so don't expect this to change much.

For example:

If I received the attached and wanted to know the total value of fund holdings in Managed and Cash, the macro will return Managed £66,159.45 and Cash £6,000.00

Ordinarily I would insert some conditional formulas and get the results this way. However, various people across the department will receive different datasheets, so ideally I'd like one master spreadsheet with a macro that will scrape the required information from the saved datasheet.

Any help that can be provided is much appreciated.