Weekly Dashboard

Would anyone be able to aid with creating a master dashboard where from approximately 12-15 sheets representing different locations would need to pull into a single dashboard 17 answers (Answers are Symbols: green, yellow & red). Ideally you can just type in the week ending so and so date and the dashboard would self populate. Not sure if that makes sense.

Best Answer