can a pivot table pull from multiple worksheets?

I have a workbook with 9 worksheets that I need to pull together for a
report. Can I use a pivot table for this? It would need to pull from all
those sheets and I don't know what the limits are.

Thanks,


Todd