Forum Discussion
Summarize data from multiple tabs on another workbook
I have a workbook that is updated and sent to me every day by another company. This workbook contains a new tab that is created for each day with the date as the worksheet name. Each worksheet has ...
I wish all the members of this community would ask their questions as you did!
A clear and detailed explanation of the request!
You just need to Get and Transform Data in Excel 2016 (aka Power Query in earlier versions of Excel).
By using Power Query, you can append all datasets in each worksheet into a single worksheet.
Before that, you need to convert each dataset to a https://support.office.com/en-us/article/Create-or-delete-an-Excel-table-e81aa349-b006-4f8a-9806-5af9df0ac664?ui=en-US&rs=en-US&ad=US and to create a new column in each table contains the worksheet name.
I leave you with this https://www.youtube.com/watch?v=TTMODKl6GNY&list=PLHrPHBbDHgT0XiXLpBaREfRpRlx8SyGkf to learn all these stuff!