Hello

Could someone please give me a shorter formula which would function the same as...

=VLOOKUP($B4,'1'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'2'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'3'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'4'!$B$3:$AZ$1000,3,0)
+VLOOKUP($B4,'5'!$B$3:$AZ$1000,3,0)

(and so on - 113 worksheets)

Thanks for your time...