I'm no expert but can read code.

I have a xlsm sheet with multiple worksheets in. I can write out the multiple worksheets as a single CSV file but I need to do a little more and have no idea where to start. Can anyone help me?

Simply put, I need to take multiple work sheets, output them as a CSV. Each line is of the format (see below, simplified):

OR

I have multiple worksheets of the format (see below) and need to manipulate them into a single CSV file.

The order that this happens in is not important except from a coding perspective. Ideally it would go from a multi-worksheet xlsm to a CSV.

-----xslm file format across multiple worksheets --------
1234,5678,9101,2345,abcde,101
6789,,,,fghijkl,102
1012,3456,,,mnopqr,103

and make that into a CSV.

1234,abcde,101
5678,abcde,101
9101,abcde,101
2345,abcde,101
6789,fghijkl,102
1012,mnopqr,103
3456,mnopqr,103

all help greatly appreciated.

etc.etc.