Sort and format help.

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.

Is each worksheet named 1234,5678,9101,2345,abcde,101, etc?

hi,

the above is the contents of 1 work sheet. there are 10 worksheets in the workbook all are the same content layout.

Its essentially a stock sheet. But one item description (abcde) can correspond to several part numbers (1234,5678..).

the columns would have descriptive headers.

part no.1,part no.2,part no.3,part no.4,Description,Quantity
1234,5678,9101,2345,abcde,101

the worksheets themselves are named "parts","servers","opticals","hard-drives","CPU","CPU-kits",......