VBA to copy cells based off of other data

First off, I've scoured this site for hours and haven't found something that works for me. If I've overlooked the post, whoops!

I've attached an example file of what I'm trying to do to help explain...

I want to take anything on the "Questions" sheet where the answer is "Y", and copy it to the "Summary" under the appropriate column header based off of the category on the "Questions" sheet.

Thanks in advance,
Alan