I am trying to get the index of each sheet in a workbook. For test purposes I have a work book with 5 worksheets named "test", "2019 Budget", "2020 Budget", "2021 Budget" and "2022 Budget".
On "test" sheet the names of the the 4 budget sheets are listed in A1:A4
I want to calculate the SHEET...