Index/Match across sheets

Hi,

I have a formula which looks across multiple columns and it returns the text which appears first. E.g. in the example below it looks in T2, if blank it then looks in U2 and so on and so on.
=INDEX(T2:AC2,MATCH(TRUE,T2:AC2<>"",0))

I need a similar formula which rather than looks across columns on the same sheet I need it to look across multiple sheets within the same cell and return it if not blank.

e.g. I have 4 data sheets and a summary sheet. The data sheets are:

• North
• Aviation
• Marine
• South

Only data is entered on the “South” sheet in cell E7 in the exmaple – this is the only thing I need to return to the summary sheet.

Can this be done?

I have included an example

Paul

Sorry - I meant to put the Sheet "Marine". Marine is the only sheet which has something in E7 (now that is)

If the model had something in the sheet Marine and also South I would need just the Marine field returned (due to its postion in the sheet).

Does that make more sense?

Perfect - thansk XOR LX