Howdy,

I have a spreadsheet that I use to track numbers from a Help Desk Ticketing System. I have a tab for each month and each tab has the same data in the same cells. E.g. B15 is always the total tickets opened. B25 is always the total tickets closed, etc.

I want to have a Dashboard tab that can make a chart that would show things like the tickets opened per month and pull from the B15 cell on each tab in the sheet. How would I go about setting that up?

Also, if I can combine two pieces of data onto one chart to show Opened and Closer per month and pull from the proper cells on each tab, that'd be great too.

Thanks for any pointers or tutorials you can direct me to.