Auto Macro the pulls data from on sheet, prints on another sheet, then deletes information

I've created a log that will keep track of miles driven on 5 cars for the month. Unfortunately, I have never learned how to write macros.

I've attached my file and on the first sheet "INFO FOR WHAT I NEED!" is what I'm looking for.

Basically what I'm looking for is a macro to run the 1st of every month that will take the Overall Total in each vehicles sheet and print the data in the sheet "Monthly Mileage" in the month that just ended.
Example: March 1st will print in February; April 1st will print in March

After the data has been printed the mileage breakdown will need to be deleted.

I also have an extra that I will like but is not needed and that is to count how many time the mileage is recorded for the month and printed on the "Checked out vs. Rec" sheet under the recorded section.

I know this is a lot to me, not really sure about you, but any help is greatly appreciated.