Simple Copy and Update Cell Value Every Minute

[p45cal]

To stop the macro, do I enter stop in between <>?

No. Just stop, or Stop, or sToP, no spaces in cell A1 of Sheet9 (The sheet called Sheet9 on its tab, not the workbook called Sheet9.
In Excel there are Workbooks (files), which contain (at least one) worksheets (sheets). Naming a workbook Sheet9 is more than a little confusing.

I get an error, so far.
Runtime error 9. Subscript out of range.
I'm asked to debug the follow code line:
With Sheets("Sheet9").Cells(3, Columns.Count).End(xlToLeft).Offset(, 1).Resize(14) 'destination sheet, to the right of data in row 3

Do you have a sheet called Sheet9? If not, either rename the sheet Sheet9 or adjust the code so that references to Sheet9 in the code are changes to the actual sheet name.