Sorry Max for my wrong statement. I mean the Heading row A1 to J1 and the data
will be in row A2 to J2. Thanks for your further help.

"Narnimar" wrote:

I have a work book that has a no. of sheets fro sheet 2 to n no. no sheets
with similar format. The top row a1 to a10 has cells with heading . I add new
this similar sheets continuously with changing data in b1 to b10. Now can I
make sheet1 as index of those sheets and how to transfer pasting the contents
of b1 to b10 data of every sheet into the row cells of sheet1 automatically
as and when the sheets I add?