fromula to get data from multiple sheets
 

I want to get the data in my final worksheet from multiple worksheets
depending upon the condition that i give is found true fro example i used
vlookup(A1,ABC,1,false) where cell A1 contains the value which I am searching
and "ABC" is the name of range in multiple worksheets, as(
Sheet1:Sheet10'!B:J) has been define as name "ABC"