Search query help required

=PROBLEM SOLVED, thank you DonkeyOte=

Hi there,

I need a macro that can search through all of my worksheets bar the first one looking for the string given by the value of cell (sheet1,A,2). If it finds the string in sheet2 it should fill cell (sheet1,B,2) with the string "True". If found in sheet3, it should fill cell (sheet1,C,2) with "True", etc.

Once it has done this, it should be able to loop and do the same for the string given in (sheet1,A,3), etc.

Looking back on what I've just written I'm not sure how well I've explained myself, so I'll try to convey what I want done in pseudocode:

For each cell (X) in sheet1,column1
        For each worksheet (Y+1) [discounting sheet1]
                 Seach for cellX.Value in sheetY+1
                           If found, sheet1,rowX,columnY+1 = "True"
        Next Y
Next X

Hopefully that'll explain what I want done and hopefully one of you macro-geniuses will be able to help me!

Cheers!