Ecxel or google sheet

Ecxel or google sheet

I have one doubt . I will enter in 100 members in one page all are different villages for serial number name age sex address and contact number and village name this is for common for hundred members in single bed sheet I want after filter each village. All 100 members details is present at the time we had using any formula are shortcut to each village separately Next 6 village member is received different separate sheet also I want need that time that formation I want.