Excel PivotTable

I need help finding the best way to combine worksheets and creating a PivotTable from all the data. Also, every month I get a new report I download and add to this particular workbook but how can I g...