I wil be adding a bottom part later. for example if the fruit is apples it will go to the apples template where it will have everything about apples( recipies , history of the Fruit, and so on ). the part i want to auto populate
is just gonna be the info part. I may have 10 people wanting apples and 3 wanting Grapes. I will be wanting to create a new sheet according to the fruit tempalte but will have their last name,fist name as the new sheet name.