Macro - Copy and paste into last column of new worksheet

[larzep]

Hi,

Can some one help me with a macro that copies data from 4 static columns in sheet A and pastes it into last columns in sheet B?

It is for a spreadsheet that keeps records of all our budgeted sales amount.

Source Sheet 'Sales Forecast' Range = B5:E27

Copy to

Destination Sheet 'Forecast Data' starting from cell B1.

So far my macro is pretty basic which is

Range("B5:E27").Select
    Selection.Copy
    Sheets("Sales Forecast").Select
    Range("B1").Select
    ActiveSheet.Paste

This is just one that i could only come up with as I am not a VBA wizz.

Would be great if someone can give me some assistance.

Thank you.