So for the second time on this project, I need help on different stuff.

Whats been done so far:
I'm setting up an automated system to filter out information from a report that I receive monthly, resort it and link 12 month rolling graphs (dynamic) into progress reports. In the original workbook I use a whole bunch of VLOOKUP formulas to sort out the data into separate work sheets and then run a macro (thanks to walruseggman) to autofill data into columns on each sheet.

Where I'm stuck:
I started creating the dynamic name ranges for each worksheet, which required 15 or so values per worksheet before I could create the 14 graphs. With a minimum of 15 worksheets, its taking far too long to create. I've found where someone else has created macros that would automatically create dynamic range names, but with the specificity I'd like in the names and the way I've created the 12 month rolling formulas, I can't seem to tweak the code to make it do what I'd like.

The ask:
Is there a way for dynamic range names to be created following a format (I1ChtVal1; I1ChtVal2; I2ChtVal1...) as well as their formulas [=OFFSET(I1ChtCats,0,1); =OFFSET(I1ChtCats,0,2)...] and then for graphs to be created based on those values? The aesthetics of the workbook don't matter, so even if I have to plug formulas or names into cells and just fill into the range names from there, that would still be quicker than entering them all into name manager manually. Also, even though all 14 columns won't necessarily be filled on every worksheet, having the graphs already made in case a new column is added would be helpful.

I've included a mocked-up workbook with what I think are all the necessary components. A full set of values for the first worksheet are also included to illustrate the name format and formulas.

Any help or advice is greatly appreciated.
Example DynNames and Graphs.xlsx