I have a report form in excel, it has several sheets with hundreds of
questions. I need to be able to get the responses to the questions out of
the report and into a csv file (one sheet on one row and other sheets on the
next rows, etc).

What is the easiest way to go about doing this?

Thanks in advance.

Gareth