I have a report that links data from other worksheets. The names of these worksheets change annually, for example "2018 Jobs Planner 2.0.xlsm", will become "2019 Jobs Planner 2.0.xlsm" next year.I am trying to calculate the name of the worksheet for the current year so it does not need to be...