Copy cells from a particular sheet on a workbook to a new Master worksheet

[robertsa123]

Hi,

I am new to this so please bare with me. I have a spreadsheet with lots of data held in many sheets. I want to copy the cells A1:A33, F1:F33 and G1:G33 from the sheet WKREPORT and paste them into a new sheet called 'Master Data'. I want to create a macro so that I can do this everytime I have a new spreadsheet sent to me and make changes if I want to. The spreadsheet is in the folder X:\Adam\Sinter Plant Data\Sinter Data 2009 OEE MACRo.
If anyone could suggest a code to do this I'd be very grateful. Please tell me if you need more information.

Thanks,

Adam

[patel]

I want to copy the cells A1:A33, F1:F33 and G1:G33 from the sheet WKREPORT and paste them into a new sheet called 'Master Data'.

new sheet to be created ?
ranges to be pasted in same positions ?

[robertsa123]

Patel,

Apologies. Yes, I would like the code to create a new sheet and also to copy the cells A1:A33, F1:F33 and G1:G33 in my 'WKREPORT' sheet and paste them into rows A, B and C respectively in the 'Master Data' sheet.

Thanks for looking into my question.

Adam