Automatically link multiple work sheets when creating multiple copies

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