Question

what help in combining the data of multiple worksheets its emergency give right answer​

Answer 1

Explanation:

Consolidate data by using multiple page fields

Add the PivotTable and PivotChart Wizard to the Quick Access Toolbar. ...

Click a blank cell (that is not part of a PivotTable) in the workbook.

On Step 1 page of the wizard, click Multiple consolidation ranges, and then click Next.