Can Excel automatically include columns pasted (in no set order) from
another sheet into named ranges on the destination sheet. 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