VBA Copy From Column A Of Last Row, Paste To Specific Cell On New Sheet

Good Morning,

I am attempting to copy Column A, last row from one sheet, and place it into a different cell on a new sheet. I have been able to create the new sheet, and populate specific cells with values, but everything I try with regards to copying column a, last row to a specific cell on the new sheet fails miserably. I am newer to vba, and have been trying to modify code to meet this need, but with no success.

Example. Row 15 is the last row, and I have data in Columns A, B,C,D. I want to take the info from column A row 15 on one sheet, and move it to column F row 2 on another sheet.

Could someone please show me an example sub of how this would work?

Here is what I have put together

HTML Code: