Automatically Append New Data in Unknown Addresses into Existing Ranges
 

This is baffling...I want to Excel to automatically include new columns
added in a sheet into previously named ranges. The defined ranges are
currently named with the same names as the column headings.

In a separate sheet, there are 5 different types of columns that are
pre-formatted 'template' columns. This is a school spreadsheet; so in a
Grades sheet, teachers can press buttons to insert the different
columns as needed for each new day. The columns' headings are on row
12 and a Attendence, Performance, Behavior, Notes, and Assignments.
The reason for doing this is because there can be several columns for
"Assignments" each day--one to record quiz scores, another to record
homework scores, etc. Also, the columns will be in no set order.

Instead of a teacher having to select each and every column to be
included in a particular range, like for the Assingments
=Grades!$AN:$AN,Grades!$AG:$AI,
is there a way for Excel to do this automatically?

row 11 1/3/07 | 1/10/07 | 1/12/07
row 12 Assignment | Notes | Assignment
row 13 Math puzzle | | Open quiz

row 15 10 points | The student... | 95 pts etc.

Any insights would be greatly appreciated.
Eric