Appreciate if someone can help me with using excel, I am very much a novice
but am really intrigued by what it can do.

I have inherited excel workbooks, containing worksheets of a roster of
duties by the week, ie each work week is on a different tab. Pls see example
below - basically in row 3,5,7, the type of case is rostered (in a validation
drop-down list), and the case identification no. is input in the cell
directly below, ie rows 4,6,8.

TAB 1
Row A B C D E
Mon 10/8/09 Tue 11/8/09
AM PM AM PM
Adam b3 c3 d3 e3
b4 c4 d4 e4
Ben b5 c5 d5 e5
b6 c6 d6 e6
Carrie b7 c7 d7 e7
b8 c8 d8 e8

TAB 1
Row A B C D E
Mon 10/8/09 Tue 11/8/09
AM PM AM PM
Adam FC xx yy FC
FC12/09 yy/09 FC14/09
Ben xx zz qq ff
xx/09 zz/09 ff/09
Carrie xx FC FC ff
xx/09 FC13/09 ff/09

I would like to create another tab within the same workbook, that detects
the word €œFC€� in any cell on row 3,5,7, and on another worksheet, return the
text below if a case no. has been assigned to the slot. Otherwise, it should
be a blank. An example what is desired is provided below.

TAB 2
Row A B C D E

Mon 10/8/09 Tue 11/8/09
AM PM AM PM
Adam
FC12/09 FC14/09
Carrie FC
FC13/09

Would really appreciate any help on how this can be achieved. Thanks!