I have an excel workbook with 40 wooksheets with names as years (1982-2022). I need to save these individual worksheets and rename eg. as imdbt1982,
I need to rename the sheets as imdbt1982, imdbt1983 ,,,…imdbt2022 and save them as individual workbooks