save a particular column in notepad
 

i want to save a particular column in notepad, my Excel i created n number
of sheets and a particular column of all the sheets to be saved in a notepad
as well as if i do any changes in excel sheet it will reflect in the notepad.
is there any Macro is available.

Thanks