Copy from first workbook, close open new workbook paste close

i would like to select a copy range from active workbook and sheet from "A2" to last populated cell in column "G"
then close this workbook. open a new workbook "workbook2" sheet "sheet1" and paste to first unpopulated row, save and close workbook