Hello all and thanks in advance.

What I am trying to accomplish is to have a consolidated list that excludes blank cells in another range. For instance:

Ranges A5:A11, A13:A19, A21:A27, and A29:A32 on 'project' tab would all contain text or blanks. What I would like to happen is have all of the non blank cells populated (condensed neatly) in a list in another range, say B4:B29 on 'quote' tab.

I'm certain this can be done, but I can't figure it out. I have included an example file to better illustrate what I need.

Any help would be greatly appreciated