With your data like that (as you showed) on sheet1....
[Table="width:, class:grid"][tr][td] [/td][td]A
[/td][td]B
[/td][td]C
[/td][td]D
[/td][/tr]
[tr][td]1
[/td][td]sl No[/td][td]Village Name[/td][td]date[/td][td]payment[/td][/tr]
[tr][td]2
[/td][td]1[/td][td]Bipulingi[/td][td]15/08/17[/td][td]$300
[/td][/tr]
[tr][td]3
[/td][td]2[/td][td]S Pur[/td][td]14/07/17[/td][td]$150
[/td][/tr]
[tr][td]4
[/td][td]3[/td][td]Mohana[/td][td]7/8/2017
[/td][td]$100
[/td][/tr]
[tr][td]5
[/td][td]4[/td][td]Bipulingi[/td][td]26/10/17[/td][td]$750
[/td][/tr]
[tr][td]6
[/td][td]5[/td][td]S Pur[/td][td]22/08/17[/td][td]$190
[/td][/tr]
[tr][td]7
[/td][td]6[/td][td]Bipulingi[/td][td]12/9/2017
[/td][td]$600
[/td][/tr]
[tr][td]8
[/td][td]7[/td][td]Aska[/td][td]11/8/2017
[/td][td]$230
[/td][/tr]
[tr][td]9
[/td][td]8[/td][td]Aska[/td][td]14/09/17[/td][td]$220
[/td][/tr]
[tr][td]10
[/td][td]9[/td][td]Bipulingi[/td][td]14/11/17[/td][td]$900
[/td][/tr]
[tr][td]11
[/td][td]10[/td][td]Mohana[/td][td]7/9/2017
[/td][td]$120
[/td][/tr]
[/table]
1st, put this into F1 on each sheet, it pulls out he sheet name. If you cannot use F1, put it where you can, but then change the reference in the other formula below...
F1=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
[Table="width:, class:grid"][tr][td] [/td][td]A
[/td][td]B
[/td][td]C
[/td][td]D
[/td][td]E
[/td][td]F
[/td][/tr]
[tr][td]1
[/td][td]sl No[/td][td]Village Name[/td][td]date[/td][td]payment[/td][td][/td][td]Bipulingi[/td][/tr]
[tr][td]2
[/td][td]1
[/td][td]Bipulingi[/td][td]15/08/17[/td][td]300
[/td][td][/td][td][/td][/tr]
[tr][td]3
[/td][td]4
[/td][td]Bipulingi[/td][td]26/10/17[/td][td]750
[/td][td][/td][td][/td][/tr]
[tr][td]4
[/td][td]6
[/td][td]Bipulingi[/td][td]####
[/td][td]600
[/td][td][/td][td][/td][/tr]
[tr][td]5
[/td][td]9
[/td][td]Bipulingi[/td][td]14/11/17[/td][td]900
[/td][td][/td][td][/td][/tr]
[tr][td]6
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]7
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]8
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]
A2=IFERROR(INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$2:$B$11=$F$1,ROW(Sheet1!$A$2:$A$11)),ROWS($A$1:A1))),"")
this is an ARRAY formula and needs to be entered using CTRL SHIFT ENTER, not just enter.
Copy down as needed, then copy all that, across as needed.
You can then copy that whole range (including F1) to each sheet