VBA to sort dates and paste to summary

Hi

I have the basic setup of the millage log going, but trying to figure out how to sort the dates via VBA and paste it to the summary sheet of the workbook.

Every vechile has its own tab, the drivers wil give me written log sheet from where I will fill in the relevant information...I want to make a button, once pressed the code should copy/paste data to the summary sheet marked in yellow.

On the Vehicle log sheet eg (Isuzu 1) there are dates (marked in yellow) I want these dates to combine as one and paste it in the summary sheet under monthly kilometers in January.

See attached pics and workbook

Thank you Keebellah, I will give it a test run, and will close the tread once happy.

Much appreciated

Regards

Originally Posted by Keebellah

If you get stuck, just holler.
The keep in mind that the month value to search in the summary is taken from the header row month value

Thank you Keebellah, modified the code a little bit, everything working 100% now.

Regards