append two worksheets with excel macro

[Moon]

Hi all,
I have two worksheets from separate workbooks that I'd like to combine.
They contain different columns and different data. So for example in
sheet 1 I have:

Col1, Col2, Col3

and sheet 2:

Col4, Col5,

I want to put them in one worksheet like Col1, Col2, Col3, Col4, Col5
with data from sheet 2 appended to the last row of Col4.
Is this possible? Any help is greatly appreciated!
Moon