How to populate sub sheets based on criteria from a master

EMS360 Posts 2 Registration date Saturday April 15, 2017 Status Member Last seen April 17, 2017 - Updated on Apr 15, 2017 at 09:22 AM

I'm working on a master file with sub sheets. I'd like to auto populate data from rows A-S to sub sheets (Dave, Jamal, Addi), based on data entered in row L (Dave, Jamal or Addi).

Is there a way to do this without having to create codes for a macro?

Thanks for any help you can offer.

Michelle Priceman