Template that can point to different Workbooks

[JKBeeman]

I am in charge of metrics for my company and we gather a lot of different information from different sources. Currently I have created a workbook that has 5 different data worksheets and 7 worksheets that calculates and displays the information. I am trying to create a Client Template where I can point to our large report and search for just the client specific information without having to dump all of the raw data into the second workbook. The issue I'm running into has to do with the fact that this is a report that is run every month, and is renamed every month. So the Client Template needs to be able to easily point to a different workbook (with the same worksheet names) and calculate the data. Is there an easy way to do this or am I going to need to write a massive VBA macro that manually enters each of the 1200 formulas?