Pull my tasks with their respective internal deadlines into master sheet 1.

[EmilywRes]

Hello,

I have a master sheet with multiple separate sheets for all my projects and am trying to make the master sheet auto populate all upcoming tasks from the project sheets into the master sheets. Is this something I can do, and how if so?

Thanks in advance!

Emily

[#2]

@EmilywRes 

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).