Formula to Match value over multiple worksheets

Hi,

I have an excel file with several worksheets, (ie Sheet1, Sheet2 ..all the way to Sheet50)

I want to create a new sheet (Sheet51) and in this use a formula to find a match for a particular value (say 10) in position G18 on all the sheets.

Is there a formula to do this?

Any help would be greatly appreciated.

Cheers