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.