Stuck with copying formulas that include different worksheets.

Hi, I wonder if anyone can help me.
So I will try to explain my query.
I am working on a skills profile and the master sheet (sheet 1) is a summary page that summarises all of the data from the other sheets. Each worksheet is identical except that each worksheet represents a person in the workplace and their various passes/fails against the preset training programme.
So the easy part is that for the first person (worksheet 2), I have just pointed the summary page to the relevant cells on worksheet 2, so that if (ie 'Debbie') passes an exam, then whatever is typed into the relevant cell on worksheet 2, will show up in a box on the summary page (worksheet 1). The idea is that each member of staff will be on a separate worksheet but that the top sheet number 1 will summarise all of of their training achievements
Each sheet from 2 onwards is identical so I just really want to find a way to copy the formula for sheet one (formula is in the master sheet 1) along for each person but that it picks up the relevant sheet dependent on the staff member.
So, to summarise, how do I get excel to recognise each worksheet for each person but at the same time picking up the same cell 'row' for the answers to appear on the summary page? Is it something to do with 'indirect' formatting?
Any help would be appreciated.

Thanks

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks very much! I have attached my mock up, hope it is clear.

you can try:
B8: =INDIRECT("'"&B$7&"'!B"&ROW(8:8))
drag to the right and down

Wow! Thank you so much, that is really helpful! I can't thank you enough