Export specific cells in multiple sheets to a comma delimited file...

Question

I have a survey with 20 sheets, each sheet has 2 columns (column A with the question and Column B for the answer). I need to export all the answers in columns B to a comma delimited text file including any blank or null cells. There will be hundreds of surveys each year so I'm trying to automate as much as possible. Is this something KUTools for Excel can assist with or should I look at a visual basic script? Thank you for any help or pointing me in the right direction if you can.

Thanx, Jeff