How do you search through multiple sheets to find a specific value?

Hi

I was wondering if somebody could help me with some code that I have adapted for searching for a specific name within a worksheet and if found then copying and pasting cell values around the found name into specific cells. My problem is that I would like to know how to search through all the sheets within the workbook. In my case there will only ever be 3 worksheets (sheets2,3 and 4) to search in, sheet1 will be for the copied data.

Here is a bit more detail:
The variable can either be on sheets2,sheets3 or sheets4 and will either appear once (throughout the workbook) or not at all, if not found then a message box saying "I could not find variable” pops up or if it found specific cells around the variable are copied to sheet1 into specific cells (always the same cells)
This my code :

Please Login or Register  to view this content.

Thanks for looking

See if this works:

Please Login or Register  to view this content.

I generally loop through the sheets in book:

Please Login or Register  to view this content.

Untested, so may take a little bug-fixing.

Thank you StephenR and Andrew-R. I have tested both sets of code and both work really well. Thanks for helping me out, I can now continue