There are some prerequisites to be able to do what you are requesting, however, there isn't any simple way to achieve an automated dashboard. However, everything is possible in excel, and thus we are able to create a similar function using workarounds.You should start by making sure that the input comes in the same format with the same file names, column names, same places etc. each day as our model is very sensitive to changes.You start by identifying the key metrics you are going to use in your dashboard and slowly build up your dashboard. The trick here is to have a dynamic link to the r...