Populating data from one sheet to another

Hey guys,
So I want to populate some cells to have the data from one sheet to the next based on if it has a "Y" then it populate. You will probably understand more when you look at the example.

So I need a formula that will look up Y and take the necessary values and place them in the reports sheet.

I attached an example.