savings excel sheets in comma delimited text

Hi,

I have series of sheets in a workbook and i want the data to export to csv format. can someone help me. the data given is in a template given below. there are around 10 such sheets, if i save as csv format, i get some junk character and the format changes. also csv format doesnt accepts multiple sheet. need help. Also can someone let me know the code to pick up only the entered data from the template below and not the headings. bcoz the headings are not in one row


Entity ID
adasdasdas

Entity (Account) Name
sdfsfsfsd

Submitted by Name
dfsdsfsfsd

Date Entered
2-Jan-13

Corporate Notes
sadasdasdfasdasdas

i have added the file. these are entry sheets ( i have added 3 sheets but actually there are around 10 such sheets) where the user will enter data. There will be around 100 such users and 100 excel workbooks with 10 sheets each.

I will be creating another csv file for each of the sheet or tab and name it accordingly.

what is required to be done is that -

2) I will be adding a comand button at the end of each sheet which will copy
only the entered cells or data and not the headings as the headings will be there in csv file. copy each entered cells and paste in the csv file under the respective heading in a row.

3) entity id is only there in 1st sheet. but i want entity id to be pasted in all other CSV files alongwith other data.

Can anyone can help me work on this code.pls reply

Thanks for replying to my post.
But This is not exactly what i want. can u please read my post and give a code