How can I make a pivot table with data from several sheets?

[Piero1]

I have a spreadsheet with a sheet per calendar month , I need to make a pivot table with the data of the 12 sheets .How can I do ?

[mahfiaz]

You could always reference all the data from one page to gather it together.

Worksheet functions such as INDEX, VLOOKUP, HLOOKUP, MATCH, OFFSET are usually helpful in similar cases.