Using Index Match when the unique data could be found on multiple worksheets

[MattEvansC3]

Hi,

I've been tasked with creating a master worksheet for locker allocation across the floor. In that worksheet I need the locker number and name of the employee. Each team has it's own worksheet/tab. All the worksheets use the same template and the locker numbers are unique across the worksheets so there will only ever be one match.

I've used Index, Match on a single worksheet but I'm struggling to have it look across the worksheets to find that unique match.

 

[MattEvansC3]

To give more context I am using the following formula;
=INDEX('Messengers 1'!$A$4:$G$400,MATCH(C3,'Messengers 1'!C:C,0),1)
Messengers 1 is the first tab, there's also a messengers 2 tab as well as 10 other tabs that I want the formula to look through