Dynamic range based on find function

Hi,

See the attached file.

- It contains three datafeeds sheet, which pulls data from an external website. (Dutch, German, Nordic)
- DataCollection Sheet, This sheet is updates when the excel workbook is opened with the data from the datafeeds sheets.
- DataSummary Sheet is the sheet which is supposed to sort the data in the DataCollection sheet into columns. (this is the problem).

I need the fomula in the DataSummary Sheet to Find the correct value based on the data of the row and data id (eg. ENOYR-10)

At the moment I only get 0, but the error might have to do with the dates not being dates... or something. If this is the problem, then I need to convert i to dates with VBA when copying it over from the DataFeed sheets to the DataCollection Sheet.

I hope someone can give a helping hand. Thanks