i want to get value from another excel sheets based on some criteria. at first look at the picture.

here in the gray highlighted cell i want to get the value from other sheet and it’ll be dynamic and the criteria will be where fiscal year =2019-20. for more clarification look at the second picture.

there could be several sheets named sheet1, sheet1(2),sheet1(3)=,Sheet1(4) and many more. now i want to search all the sheets and get only the Total amount(Marked in F colums) from where Fiscal year:2019-20 for this particular case.

Extra Information: There only one sheet contain Cell Value “Fiscal Year:2019-20” in this workbook.

I am new to excel don’t get the idea of vlookup and indirect function of the excel. Please Solve this issue. thanks.