Forum Discussion
Excel file Worksheets combined (all tabs)
An alternative could be Power Query. In the attached file you can add worksheets with blue dynamic tables for each day. The formatting into a dynamic table is done by clicking in any cell of the (not yet dynamic) table and ctrl+T.
Then you can click in any cell of the green result table and right-click with the mouse and then select refresh. The green table can be used as the basis for e.g. a pivot table.
The Query works with the assumption that all blue dynamic tables contain "Tabelle" in their name. In the screenshot you can see the highlighted name of the table which contains "Tabelle". When you open the attached file the name could show "Table6" instead of "Tabelle6" if you work with english Excel. If so all table names have to contain "Table" (because of a filter that is applied in the Query).