I’m trying to decide which is best, to create a macro (with some assistance) or to just create links from cells to a new file. Here’s what I have. I’ll be working with a new file; I’ll call “C”.
I need to link values from certain cells from file “A” and file “B” into file “C”. File “A” contains a months worth of data, each day being on a separate sheet.
File “B” contains data for only one day, and is saved as today’s date each day.
The new File, “C” will incorporate data from each of these files and will be saved daily also as today’s date.

In summary, I’ll be working with a new file actually called
Dailyproduction/08-16-05.This file will be saved each day using subsequent dates as it’s file name.
This file will need info from cells in a file called FieldProduction/Aug05, sheet16 , and will also need info from some cells in a file called PlantProduction08-16-05
I’m a novice to macros. I’m wondering if I should simply create a template with links to each cell from it’s connected file ,then do a find/replace to change the links for the next days file, for example, for the next day’s file, change the link from FieldProduction/Aug05, sheet16 to FieldProduction/Aug05, sheet17 , etc.
Seems this would be the long way around but I’m drawing a blank with my limited knowledge in Macros.
I’d appreciate the help.