Pull current rows & paste to last row

[Jamesraywebber85]

I am looking to build a code, so when I press submit it will take columns A:L from row 8 down and and paste those values into another worksheet located on my shared folder. Then I would like for the sheet to clear so the agent can start a new week.

Example: Info that needs to be copied is called "ART Workbook" and paste into the file that is called the agents name in range "C3" in the same sheet (ie c3=Ray Webber, the file name is called Ray Webber.xlsx. Any help would be greatly appreciated & I have attached workbooks for your assistance.