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:

INV

Date

Client

Client Name

NET

InvoiceItem.AmountNetValueDiscountProportion

Vat

AP

PA

BOO

PT

AU

SPEC

CS

CCH

Rent

BILLED DATE

TO BE BILLED

<colgroup><col><col><col><col><col><col><col><col span="3"><col><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>

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!!