copy selected cell with links

[reza_doang]

hi experts,

hope you can help me.
i have master data, and want copy some of them to another sheet but still have link to master data, so when i update/change that copy data, master data will get update automatically. if i use the usual way it will take much time.
so, what i want to achieve, i select data from master using control button, then run the macro then copy to another sheet.

hope you can help me.

many thanks for your help.

[Simon Lloyd]

Why not create a linked workbook so you can have specific data linked to another workbook where you get to update each time you open it?