Excel: Using a named range in one workbook to populate cells in another workbook

Excel: Using a named range in one workbook to populate cells in another
workbook

I have two workbooks--let's call them "Grand Totals" and "Monthly".
"Grand Totals" contains multiple tabs of information with products in
columns across the top (same for every tab). "Monthly" needs to pull
pertinent information into a new workbook on a product by product level.
The workaround in place of manual entry was linking the two workbooks
through cell references. However, if a new product is added in "Grand
Totals" (a new column is added), all the cell references in the other
workbooks are immediately out of date.
I was going to go through and use named ranges for all of these (knowing
that it's a ton of leg work on the front end), but I can't figure out a
way to populate cells in "monthly" based on named ranges in "grand
totals."
Note that "Monthly" is actually one workbook for every product, so really
about 35 workbooks that each need to reference specific information in
columns on "grand totals".
Any help would be greatly appreciated!