pulling in a table with formulas
 

I have a worksheet createed that has a bunch of formulas in it. It is saved
in it's own file.

Standing on its own, the formula is all junk, because there is no data to
count and such.

I want to create a macro that will put this table into a worksheet that has
the data and have all of the formulas work.

This will be a monthly report counting empoloyees and complaints. The
reason I want to have the table seperate is changes can be made more readily
to the table than the macro.

Is this possible, how will I do it?