I have two sheets

One sheet there are first list drop of school name And second drop list of teacher name

and there are $2$ cell that it is location and city but not list

and in sheet $2$ i have table all information of school name in column A and teacher in column Also in C column is location and D is city

I created first drop list based on school name in table sheet $2$ also second drop list based on teacher in table

So how to do when select first drop list the second drop list show me the the teachers name and also cells that are location and city not list update it based on first or second list when select any list For example That mean when choose first drop list like Ymama school it automatically change the second drop list to appear the name of teacher and also appear the location and city that not list

however if i choose second drop list i like sara is teacher name automatically appear the school name as first drop list also update the location and city which is not list

How can do it on excel

With use VBA