I am a novice writing an Excel 2002 template. I import external data from
sources A and B into sheets 1 and 2. There are no duplicate rows.

I have named dynamic ranges for them both to accomodate variable rows and
fixed columns.

How can I automatically copy the contents of sheets 1 and 2 into a
consolidated sheet 3?

Thanks in anticipation.