Copy a template table

Hello everyone,

The problem i have is this. I made an inventory registry, using some simple formulas and a macro that looks like this :

Dim r As Range
   
    Set r = Target.Cells(1, 1)
   
    If Len(r.Value) = 0 Then Exit Sub
   
    If r.Column <> 21 Then Exit Sub
   
    r.Offset(-5, -20).Resize(15, 20).Copy r.Offset(0, -20)

It works like this. When a code of the box is scanned in column "U", the previous table with r.offset is copied in adjacent cells of the scanned code and some cells are filled using certain parts of that code. The problem is that all of the U column cells are active and if the code is scanned in the wrong cell, the table copies badly.

I was wondering if there would be a better way of registry?

I was thinking about a "NEW BOX" button with

Application.Inputbox

in which the code would be scanned, then the last cell with a value

End(xlup).Select

would be found, the value entered nearby, and a table template from a new worksheet "Templates" would be copied in adjacent cells .

Is something like this possible.
Any tips, insights and help is really appreciated.
P.S. table in attachments
P.S.S cross-posted HERE, due to multiple available solutions. Just didn't want stick them all in one post.