I want to use multiple (just 3) worksheets to feed one report or one pivot
table.
My workbook has three worksheets with similar data. On the fourth worksheet
I created a pivot table with data from worksheet 1 and works good.

How can I add data from worksheets 2 & 3 to my existing pivot table?
Do I need to create more than one pivot table to make my one report?

Thanks.