Not even sure howw to do this, or if it can be done.

I have 5 sheet in my spreadsheet. I need to do a voolkup and see if ceel can be found on all 5 sheets.

Example. I am looking for C1 from spreadheet 2005 - and neend to look for it in spreadhseet 2004, but in all 5 of it's sheets (sheet1, sheet2, sheet3, shhet4 and sheet5)

anyone?
Can it be done?


Chris