copy entire contents worksheet into new workbook, link but editabl
 

I need to copy the entire contents of a worksheet which is used by several
collegues who need to see it looking the same always (headers in the same
order,etc). In the new worksheet (workbook) I will rearrange the data for
other purposes. However, I will need the data to be kept up-to-date as per
the source worksheet.