Macro to update workbooks
 

Hello,

I was wondering how to set up a macro so that I can copy and paste data into
a 'master worksheet' that automatically updates certain cells in other
workbooks; also, is it possible to set up the workbooks so that the data
rolls over, e.g. old data is automatically placed in a new column? Thanks