savings excel sheets in comma delimited text

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.