I am using a formula on one work sheet to find a price on other sheets
sheet2 is formatted like this a grid style price chart
StyleO 12 15
12 $215.00 $225.00
15 $225.00 $235.00
18 $235.00 $246.00

Sheet3 is styleM same formatt different prices and so on. I have 10
different sheets in total all the same format but will need at add new price
sheet from time to time


I want to shorten my formula from this
=(IF(C20=Sheet2!DA$1,INDEX(Sheet2!B$2:BH$60,MATCH( E20,Sheet2!A$2:A$60,0),MATCH(G20,Sheet2!B$1:BH$1,0 )),0))+(IF(C20=Sheet3!DA$1,INDEX(Sheet3!B$2:BH$60, MATCH(E20,Sheet3!A$2:A$60,0),MATCH(G20,Sheet3!B$1: BH$1,0)),0))+
....

is there a way to shorten the formula so I don't have to add this with the
new sheet number each time I add a new sheet?
+(IF(C20=Sheet2!DA$1,INDEX(Sheet2!B$2:BH$60,MATCH( E20,Sheet2!A$2:A$60,0),MATCH(G20,Sheet2!B$1:BH$1,0 )),0))

Thanks to all who answer