Show data for several months in one chart

HI,

I am currently working on creating a scorecard where we have a snapshot of Data for each month.

How do I go about creating a table or graph that contains information form different sources?

All of the collumn headers are the same accross the sheets and most unique identifiers will appear on all sheets.

I'm sure ther must be a simple solution but all of the examples I'm finding are where the data is in just one sheet.

Thanks