I a spreadsheet that has a tab for every month and data for (5) departments in each one of these tabs. Every month, the correlating tab (to the active month) is updated and each department has an updated 'score'. Once this is updated, the user manually updates another tab. I want to automate this update but am not sure how. In my example spreadsheet, you can see data for Jan-Mar which have been manually entered.
I am looking to copy the number from month (XXXX) into the thermometer tab and format the data to look how I have it shown for months Jan-Mar.