Split a excel into multiple sheet?/

i have a excel sheet with the unknown rows i want to split assume in the specfic row to get multiple excel?

@suneel070

If suppose 100 rows are then how you want to split it ?

its change dynamacally…but two text like “centre” and “state” are unique.so i want to divide centre excel and state excel…could u suggest me
just like that
Centre
slno location capacity number…
1 bangl 100 222222
2
3
State
Slno location capacity number
1 mum 500 522
2
3
4
5