VBA code to copy selected date ranges, from core data worksheet, to 12 monthly worksheets

[Stevie114114]

Hi Guys,
In need of some serious layman coding advice here.
so, i have a worksheet "YE18" that contains the core data, for 12 months sales invoices:

headers are:
[TABLE="width: 1375"]
<colgroup><col><col><col><col><col><col><col><col span="3"><col><col span="2"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]INV[/TD]
[TD]Date[/TD]
[TD]Client[/TD]
[TD]Client Name[/TD]
[TD] NET [/TD]
[TD] InvoiceItem.AmountNetValueDiscountProportion [/TD]
[TD] Vat [/TD]
[TD]AP[/TD]
[TD]PA[/TD]
[TD]BOO[/TD]
[TD]PT[/TD]
[TD]AU[/TD]
[TD]SPEC[/TD]
[TD]CS[/TD]
[TD] CCH [/TD]
[TD]Rent[/TD]
[TD]BILLED DATE[/TD]
[TD]TO BE BILLED[/TD]
[/TR]
</tbody>[/TABLE]

based on date range, for 12 tabs, months May to April (tabs named by month also in worksheet) i need to copy the whole line of data to the relevant month.

I also need some coding for the "billed date" column, that if it is not billed in the same month as the previous year (i will manually input the date into "YE18"), to carry it forward to the next calendar month.

I've tried to run some macros found on MRexcel, but it will only copy the whole set of data if it finds the date range, not just the date range that i actually need.

Any help gratefully received!!