I would like to be able to copy a number of different cells in a specefic row
from one worksheet to another (same document).

The criteria would be similar to the following: if A1 has a value and A2
does not have a value, copy cells A1, A3, A4, A5 from Worksheet 1 into the
next avaliable row in Worksheet 2.

Does that make any sense? Help would be much appreciated.