Urgent! Dashboard at Excel

You need to create a dashboard on a template. There is an Excel file with several tabs (specific divisions of the company), each tab has its own data (as in an attachment). It is necessary to create one dashboard so that on one sheet from the drop-down list it is possible to select a subdivision and filling in the information of the left table of the example is distributed automatically, i.e. Depending on the number of people in shifts and the selected unit. Red is a significant time, the rest is night time. Also, when choosing from the drop-down list, you need to make it possible to choose a set for all splits.