Looking Up A Value With Different Headings in the same Column

[VincentJT]

Dear All,

Would appreciate if someone could help me with this. I have a worksheet as attached. I would like to lookup a value based on the dates (which are in rows) and currencies (which are in columns). However, in the same column, I could have different currencies.

An example is

Value Date AUD JPY NZD
11/08/2011 18,000 19,000 17,500
11/09/2011
11/10/2011

Value Date HKD SGD EUR
11/08/2011 143,270 120,000 150,000
11/09/2011
11/10/2011

So I would like to lookup 11/08/2011 and return the values for the different currencies in a different sheet in the following format

Value Date AUD JPY NZD HKD SGD EUR
11/08/2011 18,000 19,000 17,500 143,270 120,000 150,000

Additionally, this is a culmulative report, i.e. the number of rows will keep increasing.

Will be extremely grateful if someone could help me with this.

Thank you!

Best Regards,
Vincent