I have two files, template.xls and working.xls.

I've just added a new worksheet to template.xls and I want to copy/paste
this worksheet into working.xl.

When I do, the layout gets copied, but none of the underlying functions that
I set up.

Surely, there has to be a way to copy a worksheet, including its underlying
functions, into a new XLS file.

Working.xls has a month's worth of data entered so I REALLY do not want to
create a new working.xls based on the modified template.xls.

Thanks!