Populating data from one sheet to another by indexed values

Hello, I'm relatively new to excel VBA programming and i have an excel sheet that needs to be saved in different filenames based on data from a master list. Master list has many entries indexed by "Name". so for each name i need to populate some details from the master sheet into another sheet in a specific format. and the file has to be saved with the "Name". I've attached a sample of the sheet that needs to be filled out. Can someone please help?