How do I setup radio buttons to display different worksheet data in graphs

Hi All

I am a university student doing an internship where I have to create a dashboard for the company to be able to, at a glance, get a reasonable indication on how things are going in the various departments.

I've attached a jpg of what I've conceived so far. What I would like to do also is, as can be seen at the top left, have radio buttons that a user can click on to retrieve from a difference worksheet appropriate data and have the graphs instantly update to that relevant information. So a single button will access 6 or more sections of data and pull it into the graphs on the dashboard page.

Problem is I have no idea how to even ask what I'm looking for! Therefore I have no idea how to search for what I am wanting. So if you have an idea as to what I maybe looking for could you point me in the right direction either here, google or a couple of excel references.

Thx in advance

PS wonder what the Internship Coordinator will think when I say that my three years of university did absolutely nothing to help me on this project...