Copy a range to other worksheet & Export to pdf format

Hi Sir / Madam

i'm looking for the script to copy a range of data to another worksheet,please refer to the attached file. when i press the " INVOice" button it will copy the range from B15:F44 to worksheet "Invoice register",

example
INVOICE NUMBER CUSTOMER NAME Invoice Date INVOICE TOTAL Product Name Quantiyy Cost Total
INV 01 808 01/07/2013 12.80 B15.range D15.range E15.range F15.range
INV 01 808 01/07/2013 12.80 B16.range D16.range E16.range F16.range

2nd is after i presss the invoice button it will export to folder with pdf format follow by worksheet name and date, example

worksheet name :MR 808,
export to destination like C:\MR 808 \270913.pdf

Thanks in advance
steve

Anyone can help me on this . TQVM