I am using Excel 16.37 (Office 365 Version) on a Mac and I would like to create a pivot table using data from multiple sheets (preferably without using VBA Script).
Each sheet contains data for a specific year. The format of the data (row labels, column headings etc.) is essentially the same for each sheet. One solution is to copy and paste the data one below the other, but this is extremely inelegant.
I am using the version on a Mac so I can not install Power Query, Power Pivot etc. It is the version of Excel given to students from my university so I can not install add-ins.
I have read many posts in the Microsoft Office help forum and also tried watching YouTube videos etc., but all of these require a version of Excel on Windows in order to install add-ins etc.
Is there a way that I can easily create a pivot table by using data on multiple worksheets in my situation by simply using the tools provided with Excel 16.3 (Office 365 Version) on a Mac without installing add-ins etc. and without using VBA script?
If this is not the correct place to ask this question, please let me know where I can post it.
Thank you for looking at my post.