Data Filter/Consolidation

[Jedi Master]

I have a master worksheet that looks at 50 identical worksheets like the below:

I want to pull entered info from the 50 identical worksheets to the master and consolidate. For example, Quote Task Worksheet looks like:

and Quote Task Worksheet (2) looks like:

The formula I am looking for would consolidate info entered into all 50 Quote Task Worksheets in the Quote Task Master and look like this:

I am trying to make a version of the following formula work, no luck yet: =IF($M19="","",CHOOSECOLS(FILTER(HSTACK('Quote Task Worksheet '!A50:K73,'Quote Task Worksheet (2)'!A50:K73),'Quote Task Worksheet '!D50:D73>0),1,2,3,4,5,6,7,8,9,10,11))

Not sure how or if I need to filter the multiple sheets, if I am only grabbing entered info, then I dont think I need to filter anything.

 

[Jedi Master]

The code worked properly on a dummy file. Could you upload a copy of your file (de-sensitized if necessary) to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

I'm sorry, this solution doesn't work for me. Perhaps a community member could post an alternate formula based solution?

 

[Jedi Master]

Solved! Used variation of the following thread formula: Vstack/Filter Function Help

=LET(X,VSTACK('Quote Task Worksheet '!A50:K73,'Quote Task Worksheet (2)'!A50:K73,'Quote Task Worksheet (3)'!A50:K73,'Quote Task Worksheet (4)'!A50:K73,'Quote Task Worksheet (5)'!A50:K73,'Quote Task Worksheet (6)'!A50:K73,'Quote Task Worksheet (7)'!A50:K73,'Quote Task Worksheet (8)'!A50:K73,'Quote Task Worksheet (9)'!A50:K73,'Quote Task Worksheet (10)'!A50:K73,'Quote Task Worksheet (11)'!A50:K73,'Quote Task Worksheet (12)'!A50:K73,'Quote Task Worksheet (13)'!A50:K73,'Quote Task Worksheet (14)'!A50:K73,'Quote Task Worksheet (15)'!A50:K73,'Quote Task Worksheet (16)'!A50:K73,'Quote Task Worksheet (17)'!A50:K73,'Quote Task Worksheet (18)'!A50:K73,'Quote Task Worksheet (19)'!A50:K73,'Quote Task Worksheet (20)'!A50:K73,'Quote Task Worksheet (21)'!A50:K73,'Quote Task Worksheet (22)'!A50:K73,'Quote Task Worksheet (23)'!A50:K73,'Quote Task Worksheet (24)'!A50:K73,'Quote Task Worksheet (25)'!A50:K73,'Quote Task Worksheet (26)'!A50:K73,'Quote Task Worksheet (27)'!A50:K73,'Quote Task Worksheet (28)'!A50:K73,'Quote Task Worksheet (29)'!A50:K73,'Quote Task Worksheet (30)'!A50:K73,'Quote Task Worksheet (31)'!A50:K73,'Quote Task Worksheet (32)'!A50:K73,'Quote Task Worksheet (33)'!A50:K73,'Quote Task Worksheet (34)'!A50:K73,'Quote Task Worksheet (35)'!A50:K73,'Quote Task Worksheet (36)'!A50:K73,'Quote Task Worksheet (37)'!A50:K73,'Quote Task Worksheet (38)'!A50:K73,'Quote Task Worksheet (39)'!A50:K73,'Quote Task Worksheet (40)'!A50:K73,'Quote Task Worksheet (41)'!A50:K73,'Quote Task Worksheet (42)'!A50:K73,'Quote Task Worksheet (43)'!A50:K73,'Quote Task Worksheet (44)'!A50:K73,'Quote Task Worksheet (45)'!A50:K73,'Quote Task Worksheet (46)'!A50:K73,'Quote Task Worksheet (47)'!A50:K73,'Quote Task Worksheet (48)'!A50:K73,'Quote Task Worksheet (49)'!A50:K73,'Quote Task Worksheet (50)'!A50:K73),FILTER(X,INDEX(X,,1)<>""))