How to use macro to copy data from workfile A to workfile B

Hi,

COuld you please advise me how can I use macro coding to copy data from workfile A to workfile B? Example details :-

Source data copy from:-
'File name:WorkfileA
'Sheet name: InboundRecord
'Range:A2:Z2 to Selection.End(xlDown)).Select

Paste to :
'File name:WorkfileB
'Sheet name: Inventory
'Range:A:Z & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues

Hope to get your kind advise. :)