Pasting text from multiple rows along 5 columns into new column

I am looking for a macro that will take the cell contents from multiple rows in five columns (A-E) and paste them into a new column with spaces and/or commas. So, for example:

Amy	likes	Suede	in	May
Mary	likes	Leather	in	June
Scott	likes	Cotton	in	July
Sean	likes	Silk	in	August

Becomes

Amy, likes Suede, in May
Mary, likes Leather, in June
Scott, likes Cotton, in July
Sean, likes Silk, in August

I need a macro because the cell contents and number of rows change regularly. Does anyone have any ideas?

Try this :

Please Login or Register  to view this content.

Please click the * below if this helps

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you all! JasperD's code is closest to what i am looking for! (AB33 doesn't have commas and jindon has too many ;-) ).

JasperD: What is the proper code to end the macro when there are no rows with text? Currently it goes down the column for infinity.

Ahh

Please Login or Register  to view this content.

jindon, perfect! Thank you!!