Generate subsheet or workbook based on master

Hi all

I need a macro that can copy data from a master sheet onto either a subsheet or another workbook. I would very much like the following:

- be able to set a column range so I can pick out certain columns to be copied, as well as a row range. What would be extremely neat, is if the columns are a part of the macro i.e. fixed, while the row range could appear as an input option when the macro button is clicked.

- because I need 3-4 specific subsheets or workbooks copying different columns from the mastersheet, and those who are gonna use it are very unskilled in excel, I would like it as a macro button that can be named.

- it needs to be quite simple, because I'm quite the beginner at this stuff, which also means that a short tutorial would be much appreciated.

- it also needs to function in both excel 2010 and 2013.


In advance, thank you so much for your help and sorry for butchering the macro lingo.

Kind regards Chris