Creating drop down with MATCH and dependent cells

I have 4 admin levels. I have a sheet with all the data of admin levels. I wanted to create the drop down menu in a different sheet so that the drop down is generated on the basis of the selection of different admin levels. E.g. on selection of the first admin level, the list of admin two should be generated in the second column and on the basis of the selection of the 2nd column, the list should generate on the third and so on on the fourth. Also, some names are repeated in different admin levels, so the selection of dependent cells should match all the selected items. how do I achieve this? Your support is highly appreciated.

Thank you brother, I have gone through these videos and other videos on YouTube as well but ended up with no luck. If you could help, I can send you the file. I have successfully created the dropdown till the third admin level. I got stuck on the fourth one. Kindly send your email so that I can forward the file.

I was unable to upload the file here. So I uploaded it in the google drive. Please find it below. The first three columns are fine, on the fourth column i want the villages list to
be displayed in the drop down on the basis of the selection of first three cells. Please note that some names in column 3 are repeated in different sub zones, so the function should match
all the three cell's value and return the value.

drive.google.com/file/d/1793-nlBjETUWzqVHo25vlW-ELdFJ1GBI/view?usp=sharing

Thank you for the support. This helped a lot, just small help more, I see when you extend the by dragging the bottom corner of the last column so that the same formula is copied to other rows,
the drop down menu disappears in the village column. For your reference, find the file: drive.google.com/file/d/1SVw2mU7Y-MkutlcKHewkqwU_XEOc_o9G/view?usp=sharing

Thank you!

The rows below displays the same list as in 2nd row. Even without making any selection in 1,2 and 3 columns. Also the dropdown menu does not display in the rows below. in the 3rd row it is displaying the wrong drop down menu, and rows below it does not display any list. Please help.

Plese findit here, with comments: drive.google.com/file/d/1-2q0UFOXCf8ZfflenKSpKmE0opLSAb8B/view?usp=sharing

Could you please provide response to this, so that I can proceed ahead?