Creating a Dashboard from Multiple Sheets

Options

I have set up an Issue tracker for each of my clients. I want to create a Dashboard so I can see an overview of all outstanding issues, without having to go into each client's sheet. How do I do this, or is there a better way to set this up? Thanks!

Answers