I have a work book with multible tabs, these all have referance numbers on them with an amount, what i want to do it is look down column a in all 10 tabs then look down column f for the amount, if it matches the referance number i have it will produce me the amount paid, i know how to do this for one tab but not mutiple tabs, below is the formula for one tab 
=SUMPRODUCT((CME!A3:A1000='PPP''S WRITTEN'!B5)*(CME!F3:F1000))
the tab names i have are AYA,ALB,CME,DAT,DNN,NMO,PBO,ROC,SEA,SGR,TIL

Thanks in advance

DJ