VBA Exporting SubReports as CSV files from a sheet

[k0023382]

First of all, I will be very grateful if someone could help with this.

I have a long report on a sheet with over 1000 subreports. It looks like this:

columns A,B,C,D
Name,Target1,Target2,Target3
SubReport1,1,0,0
SubReport1,1,1,6
SubReport2,1,0,0
SubReport2,1,0,0
SubReport2,1,2,6
SubReport3,1,0,0
SubReport3,1,0,7
SubReport4,1,0,7
SubReport4,1,2,0
SubReport4,1,0,0
etc

I need to create a CSV file from each subReport (without the headings)

SubReport1.csv contains
SubReport1,1,0,0
SubReport1,1,1,6

SubReport2.csv contains
SubReport2,1,0,0
SubReport2,1,0,0
SubReport2,1,2,6
etc

I wonder how can to do this with VBA, so I will have as many CSV files as SubReports
Some sheets contain over 1000 subreports, I need to generate this every month.

After trying with autofilter and SaveAs method I took me nowhere.
It has to be an easy and direct way of doing

Many thanks in advance