Copy and Paste Depending on Cell

Hi,

I want to look at column B and then anything that has say EUR i want to highlight all of the rows which have this value and the corresponding information in columsn A to L, then copy this information onto a new workbook in cell A1.

I then want the macro to go through all the currencies and do the same, so GBP, CHF, USD etc.

Any help would be much appreciated. Thanks.