Help with SQL Query to write data from one DB table to another for a monthly report

After some testing, I was able to get it to work using your combined query and modifying it as needed. I appreciate the help and patience.