Formula checking multiple worksheets

[sonic-the-mouse]

I have been tasked with streamlining a spreadsheet used at work. It
previously had 28 worksheets
A sheet for each month of the year to list occurences
An audit sheet for each month and
A couple of statistc sheets.

The monthly sheets list events numerically although the numbers are not
consecutive.

I want to only have one audit worksheet which will search the monthly
sheets looking for the event that is numbered in cell C10.

The previous formula was

=if(isblank(c10),"",vlookup('Jan'!a2:t999,2,false)).

How can I adapt this to look up all the monthly worksheets to find the
event number? There are a number of formula in the audit sheet which
will read further information in the same row. Any assistance is
greatly appreciated.

stm

 

[Biff]

Hi!

It's not clear what you want.

Do you want to lookup a value that is on each sheet or do you want to lookup
a value that may be on any sheet?

Biff