VBA Copy/Paste Confusion

I have asked this a few times recently, but have not gotten much (read: any) response.

I am creating a new worksheet names "Temp".
I am populating Column A with Field Names, and am having issues with copying data from cells in the last row of "Project DB" Sheet, into the "Temp Sheet" in the cells corresponding with the newly created field names (Column B)

Here is the code I am working with (Workbook is attached as well). The [Email Notifications] button on [Userform2] is where tis code is located. (my next step will be to copy the range in the Temp sheet into an outlook body, which i have done before, then kill the new sheet.

I simply need help troubleshooting this formula to copy and paste last row data.

HTML Code: 

I would be truly grateful for ANY type of assistance.

Thanks.