Using std template to update monthly data

I have createded a worksheet template that is saved and used monthly to
summarize data exported from another db. The cell references in the template
that coralate to the importated data never change nor do the names of the
imported worksheets.

The problem I have is when I copy my template to the new workbook with the
next months data and recalc, I still get ref errors. I have to manually
click into each cell / formula to eliminate the err and get the data. Is
there a way to have this information updated automatically when I copy my
template into the new workbook?

Thanks,

Greg Y