I wanted to create a sheet that would display a person's data from various functions throughout the year. So there would be a table template, and all the data would change, depending on who was selected from the drop down list.

Would this be done using a specific formula function, pivot table, etc?


Thanks in advance!