Copy sheet from Workbook 1 and move to the end Workbook 2

[IAP]

I have Tried using almost every code on the internet and just tried MrExcels code below, and I just keep getting errors.
Sub CopySheetToNewPage ()
Workbooks.Open Filename:="C:\Users\jfjen\Desktop\New Mold Program\AAA Master File\Location Forms.xlsm"
Sheets("Location 2").Copy After:=Workbooks("A12.Basic Reports.xlsm").Sheets(Sheets.Count)
ActiveSheet.Name = "Location 2"
Workbooks("A12.Basic Reports.xlsm").Close savechanges:=False
End Sub

Workbook name - Location Forms.xlsm has a sheet named Location 2.
I want to copy and Paste sheet named Location 2 into Workbook named A12.Basic Reports.xlsm
After a sheet named Location 1

 

[IAP]

Tried every way and combination. Either Line goes Red or back to Yellow.
Same thats happened for days.
Thank You for helping so long, but I think its time to give up on the idea that this will work and I will have to try to rethink my program.
It seems like it should be so simple, buts its very hard for the person that is a novice.

 

[Fluff]

If you open the Location Forms file & select the Location 1 sheet, then run this

Sub Check()
   MsgBox "|" & ActiveSheet.Name & "|" & vbLf & Len(ActiveSheet.Name)
End Sub

What exactly doe the message box say?

 

[IAP]

I gave up on that code.
I found another when I was closing out on another site just as I was giving up.
I plugged in the same information and it ran the first time.
Thanks to everyone that was helping me.