I would really appreciate some help with this. I've done a fair
amount of googling and only come up with partial solutions.

Scenario:
2 worksheets in a workbook. Worksheet 1, column A, contains values
and blank cells at random. Worksheet 2 needs to compile a list, in
order of appearance, all values from Worksheet 1's column A with two
exclusions. The first exclusion being blank cells (null values). The
second exclusion, for example, being the value of "1".

Can this be done with an array formula in Worksheet 2? Will this
require VBA? Any example code would be much appreciated.

Thanks in advance.