Register now or log in to join your professional community.
Having all data available on single worksheet makes it really easy to create pivot tables, however it may not allways be possible to keep all data on single Excel worksheet requer to create pivot tables using data from multiple worksheets.
Pivot table can be created with the data sources being present on the same Workbook.