Automatically link multiple work sheets when creating multiple copies

Hi Forum

I am trying to link cells from multiple work sheets to one main front work sheet (within the same work book). I would like to be able to make multiple copies of an outline information sheet that automatically transfers data from the front sheet - taking the information from the next line down for each work sheet.

I would also then like some of the information collated on each work sheet to automatically fill in on the front sheet, again on consecutive lines. Instead of manually going to each work sheet and putting in the links for each one, is there a way I can short cut it when I create the copies of the information sheet?

Also, is it possible to have the name of the tab on the work sheet (e.g.1, or 2, 3,4 etc. in this case) linked to a cell on the worksheet?

I have attached an example of what I am trying to do to help explain what I am trying to do.

Thank youlinks.xlsx

Excel help version.xlsxHi JBeaucaire

Thank you for you help. I have been trying to put the formula you outlined above into my original worksheet, but it keeps coming up with #REF!

I am not sure where I am going wrong. I have a much larger table, but don't think this should matter. I have used the function "create from selection" to label my table across the top row and left hand column, but this doesn't seem to have helped.

Would you please have another look at this slightly larger table I have put in and show me how to link the first lot of data from the 'summary' sheet (I renamed as realised was not a good name as you mentioned) onto the worksheets 1, and 2. Can you then show me how to link the amount of metres walked for each person back to the summary sheet - I assume this would be the same formula, just in different order?

Then if I was to create many more work sheets for each person (approx 80), can I use the Pt number on each worksheet to identify which row of the summary sheet to select the information?

I am pretty new to Excel, so if you can explain all the bits as you go (very simply )I would be most grateful.

Thanks again