I am looking for help on how auto fill from one workbook in Excel 2010 into another. The problem is that the worksheets that will be autofilled are produced from a template and once produced are re-named depending on user or project. If anyone could give me some insight into my issue I would really appreciate it.

Thanks!!!