I am trying to lookup data in a 26 page spreedsheet based off a client number. Each sheet is labeled as a letter to organise for surnames. Each sheet has the following table:

```
Surname | Forename | Client Number | Daily Ticket Count | Monthly Ticket Count |
Ticket No | Date | Ticket No2 | Date | Ticket No3 | Date | Ticket No4 | Date | 
Ticket No 5 | Date

```

I'm searching by client Number to pull all assigned tickets. This formula below is to only check Ticket No, and then there is another formula in another cell to search Ticket No2. Repeat for Tickets 3 to 5.

This is my current formula. I was planning on repeating this entirely for each sheet A-Z, but that isn't feasible apparently. Is it possible to still do this by using another function, and if so what function?

```
=IFERROR(INDEX(A!F2:F36,(MATCH($B12,A!C2:C36,0))),INDEX(B!F2:F36,(MATCH($B12,B!C2:C36,0))),
 INDEX(C!F2:F36,(MATCH($B12,C!C2:C36,0))))

```