Using Pivot tables to get data from multiple worksheets

[rainbow62]

I want to use multiple worksheets (one for each month) within a workbook. The Pivot table was set up and worked great with just the one sheet. How do I get it to look in all the sheets? I can use either 2007 or 2010 versions of excel