Compare columns and insert values in correct place

Sorry, I didn't read well the first time what you said. Here goes the file, maybe you'll find it a bit more complicated than at first.

The sheet I want to write in is "Base de Dados" (the new lines will have the new Numbers and respective Type and the rest of the columns will be left blank, to later be filled manualy one by one), and I want to insert the numbers from sheet CADIM and also from sheet AUTOCAD.
Module3 is the one i'm writing in, you can delete what is there.

Have a nice weekend!