Hi have a sheet that pulls data from a different sheet based on the value used in a drop down menu(data validation)
I'd like to print out each option automatically (there are around a hundred).

What are my options? Am I going down the wrong road with using a list and data validation?

Thanks