i want to get numeric data of individual employees sheets depending on the department they are in i have set this function up:

IF(Workings!B3="Project Management",INDIRECT("'"&Workings!C3&"'!$p$16"),0)

i have set up three sheets one is the individuals containing their data and the devision they are in. The next is a workings sheet which collects the sheet name/employees name the the devison
the final sheet searches the workings sheet for a match in job title, in this case its "project managment" then collects the data in cell p16 from a matchin employees sheet.

the problem is i need to look at 25 sheets and sum result. as you can see this formula is going to be way to long!

any ideas?