Copying data from column heads to the rows based on a condition

HI I need your help in the following. The macro should do the following task

Columns E to J marked in yellow are the output cells. This is where the output should be displayed

Columns from K to BE are the input columns

If there is 'Yes' in any of these column, then the column heading should be copied and pasted in the output cells

The same should be repeated for all the rows. Please help me out in this macro

you can paste it in any order in the columns E to J

I just gave this sheet as an example as the oringinal sheet has confidential details

All i want is the column heads for ' Yes' cells

Eg:

if in row 2 , the column AB1, AB4, AB6 has 'Yes' then these heads AB1, AB4, AB6 should be copied and pasted in the columns E to F in any order.

I just used 7 cells as an example. You can add more yellow columns and fit those 19 values. I didnt realise there would be 19 'Yes' else i would have added more columns

@natefarm @skywriter

Please help me out. I need to make an analysis based on this

Hi,

Thanks a lot Natefarm. But the macro is not working if i add more yellow columns to accommodate more 'Yes' heads. Currently i have only 7 yellow columns. But if i add more yellow columns it is not working. What should i do?