Pivot Table How To Change Data Source
Select the options tab from the toolbar at the top of the screen. As you can see in above image the table range field refers to sales jan worksheet and clicking on sales feb will change data source for pivot table to the new worksheet. Change data source one pivot table.