Forum Discussion
Pull my tasks with their respective internal deadlines into master sheet 1.
An solution could be Power Query. In the attached file you can add worksheets with blue dynamic tables for each project. 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 in the master sheet and right-click with the mouse and then select refresh.
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 "Table1" instead of "Tabelle1" 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).