IF FORMULA

Hi I have been using an IF formula but I cant figure out how I can get it return text from another cell.  example I have a list of names in column A and in columns B-F I have a yes or no next to the names and I want to create a formula to list all the names that have yes under each column. At the moment my formula has the individual name in it but I want to replace the name for the cell that the name is in incase my list of names change. Hopefully this makes sense and someone can help me.