Creating dynamic reports:displaying rows from different tabs only when they're not blank

[StefaniaLa]

Hi there

I need 5 different "final reports" as outlined in the attached Excel file "Book 2". What I currently struggle with, is to get a dynamic list without pivot, that displays as many rows as are entered in the 3 different input tabs. I.e., in the 3 blue input tabs, we might have 20 rows with entries, then 20 rows need to be display in the final report tab, or only 2 (with the rest empty), then the list would be much shorter and limited to 2 rows only.

Any help is greatly appreciated!
Kind regards and many thanks