Keywords needed- Import data then Macros insert specific data into format

I would like to research and write the code myself, but I am having a difficult time putting in the correct keywords to get the instructions I need.

Task- Import data with 35 fields. I want to then create a macros to turn the data into a form (another, specifically titles spreadsheet) which only includes 8-9 fields, in a specific, formatted order, to submit to my sales force.

Keywords that have not worked are 'transfer data from one spreadsheet into another', 'convert spreadsheet into form', and many other variations of the like.

Suggestions? I have been running a family business for the last 8 months and have become very rusty with my VBA. (even though I still considered myself a novice, who want to learn myself)

I have attached a spreadsheet illustrating the before and after.

Thanks.