Using Sheet name to get value

[dknipe]

Hi
I have a sheet called 2017-2018

I have a cell formula that works:
=SUMIF('2017-2018'!I:I,'Income & Expenditure'!B3,'2017-2018'!F:F)

What I want to do is have several sheets with yea periods; 2017-2018, 2018-2019 etc
In my Income & Expenditure sheet I want a drop down cell say A1, that lists the year periods. Thats fine

But how do I adjust the =SUMIF formula to use the value of A1 to replace the '2017-2018'!I:I part, so it will pull result from respective sheet?

 

[Joe4]

Use the INDIRECT function.
See here: https://www.contextures.com/xlFunctions05.html