Hi folks,

I'm looking for some help to create a macro that will pull data from several sheets, ignoring any blanks and produce a combined list.

For example, if sheets 2 and 3 looked like this in a coloumn of data:

Sheet 2
Column A
Answer 1

Answer 3
Answer 4

Answer 6

Sheet 3
Column A
Answer 10
Answer 11

Answer 13

I need the following to be created on Sheet 1:
Answer 1
Answer 3
Answer 4
Answer 6
Answer 10
Answer 11
Answer 13

The macro will be attached to a button on Sheet 1 that when pressed will pull all that data. (I can do that no probs, but don't know how to get it to ignore the blanks!)