Advice needed/suggestions on how to insert multiple records

I need some advice or suggestions on the best way to accomplish this.

I have a table with records imported into our system, and it’s like a temporary table. I have a search field and the user types in the identifier of the records he wants to return. Simple so far. Then I want to insert those found records into another table. No updating or anything, basically a copy from one table to another. I’ve looked at the multi insert, insert with a repeater but not really sure what the best approach is.

If anyone can give some insight I would appreciate it.