I am trying to transfer data I have recently inserted into a table to another table in the same database

The insert is working however when I tried to create the query for data transfer I have problems with incorrect syntax and I am unsure how to fix it. I am not even sure if I am using the correct query

I am quite new to this department so I would some help if possible

TLDR: I am trying to write a query that transfers any data I have inserted from one table to another every time 

This is my query:

```
CREATE PROCEDURE [dbo].[sproc_tablename]
    INSERT INTO table1 (Name1)
        SELECT Name2
        FROM table2;
        WHERE tbl1_ID = tbl2_ID

```

![Here's how it looks like](https://i.stack.imgur.com/Byodl.png)