When the data is ready, place the cursor anywhere in the data. That will include all the worksheet data in the report. Or select just the data you want to use in the report. Then, on the Insert tab, in the Tables group, click PivotTable, and then click PivotTable again. The Create PivotTable dialog box opens.
Select a table or range is already selected for you. The Table/Range box shows the range of the selected data. New Worksheet is also selected for you as the place where the report will be placed (you can click Existing Worksheet if you don't want the report placed in a new worksheet).