I am trying to compile data into a single table (5 columns
wide) from two worksheets. The problem I am having is
that the number of rows on both lists is going to vary
over time and I need to pull it into a single list
(without blank rows). I know there is an easy way to do
this without using a macro, but I can't seem to figure it
out. I have tried using something like this, but without
success:

If(isblank(Sheet1!a2),(sheet2!a2),(sheet1!a2))

What I really need is a formula that will recognize when I
have reached the last row of the first sheet and need to
swtich over to the second sheet.

Any ideas?