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

In sheet $1$

The range of first drop list is R$1$

The range of second drop list is S$2$

The range of cell location is S$4$

The range of cell city is S$5$

In sheet $2$

The name of table is Tablexx

The range of school name is A$2$:A$7$

The range of teacher name is B$2$:B$7$

The range of location is C$2$:C$7$

The range of city is D$2$:D$7$

How can do it with use VBA code on excel