Piece of cake !
Make sure all the sheets used to hold data have the same headings. On a seperate sheet create a pivot table using consolidated ranges (with pulls all the data together).
The rest is basic PT stuff.