Search workbook for rows which have same name and copy these rows in a new sheet

Hello, please can you help? I use a workbook with 4 worksheets where a person's name may be in rows on each of these sheets. I wish for the sake of speed to be able to search for a certain person that may be entered on the different sheets which then are automatically copied onto a new sheet. I hope that the above makes sense. I will be extremely grateful if you can help me, you will save me lots of time if you can. Thank you in advance, Rammytel.

Try this...

'1stSheetname'!A1 on the worksheet you would like the name on. You can copy and paste the formula. Include the single quotes, just substitute the name of the main sheet with whatever you have named it. If this isn't clear, I can email you an example.