linking daily workbooks for a month to date total. our products
continue to change on a daily basis, so i am having touble linking
because the daily total cell changes from day to day depending on
total products produced, because of this i am unable to create a
template with a constant link.

i can easily replace the workbook name in the formula, but the
constant changing month to date cell location is causing a problem.