Extracting columns from protected workbook

I want to create a new workbook which displays only a subset of columns from the source workbook and also automatically updates everytime there's a change in the source file.  The new workbook should...