Required vba for make index sheet in workbook

HELLO SIR

WE HAVE 608 EXCEL WORK BOOK FILE...IN EVERY WORKBOOK WE HAVE 18 sheet...
in last we have a index sheet..
we want to make a index in index sheet.. every sheet last line column a, e, f, g colum data copy as a index line in index sheet with sheet name project

for eg .. sheet 1 (chaudikaran that last line above column data a,e,f,g copy in index sheet infront of chaudikaran line, column c,d,e,f

currently we attach a sample file with 6 sheet but in original have 18 sheet data in hindi fonts so we make sample 6 sheet in just sample data with example names

hope we clear my proeblem and we got a valuable code for solve my problem..

my sample file is attach..

thanks in advance..

Hello sir..

It works as per my requirement but every sheet we run macro.. is there any option one time macro run and index sheet creat..
for eg in my sheet 7 sheet the we run macro 7 time then create index..