VBA code to convert a table into a data base

I need help with a VBA code in order to insert diffrent informations from diffrent sources into one data base. Please look at the screens below : I want to go from this

to fill this