Detecting where to Insert, Delete, or Rearrange Rows using Values and Dates

Hi Programmers,
I'm a kid teacher and want to outline my lesson plans in Excel. I'm planning a new class and am anticipating not being able to accomplish everything planned for a lesson; thus needing to do those things the next day. Therefore, it'd be great, say, if there could be a way to auto-rearrange certain lesson items outlined for today and insert them in tomorrow's set of rows--but this brings up some other issues...

Attached is a sample worksheet. Here are some assumptions:
--Different days or lessons will have a different number of rows.
--A lesson outline contains 8 parts: Title, Objectives, Topics, Materials, BellWork, Activities, Homework, and Assessment.
--Different lessons will have different numbers of rows (LESSONITEMS) in these parts (LESSONPARTS).
--Daily lessons are separated by a blank row.

Cells in Col C for instance, named CTRL, are where it would be great to do the following:
When clicked, pop-up a window with the following options:
1. Copy the LESSONITEM to the first row of tomorrow's same LESSONPART (if not blank), bumping the rest down.
2. Copy the LESSONITEM and the rest of the items for that LESSONPART to the first row of tomorrow's same LESSONPART, bumping the rest down.
3. Reorder the LESSONITEM with the LESSONITEM above (if the cell above is not blank or have a different LESSONPART in col D)
4. Reorder the LESSONITEM with the LESSONITEM below (if the cell below is not blank or have a different LESSONPART in col D)
5. Copy the entire lesson (all LESSONPART LESSONITEMS) to a particular weekday (entered in col B; maybe open a calendar for the user, which will ripple the other lessons down to the next weekday)
6. Add a new lesson for this date (applies to days lacking lesson plans in row 285 and down; this would copy the template in the LESSONTEMPLATE sheet and insert it for that day)

Note that the original way to insert and delete rows in Excel should still be possible.

Here is the list of col headings:
A = WEEK
B = DATE
C = CTRL
D = LESSONPART (subparts = Title, Objectives, Topics, Materials, Bellwork, Activities, Homework, and Assessment)
E = LESSONITEM
F = ITEMINFO
G = XTRAINFO
H = REVIEW Y/N
I = DELETE Y/N

I realize this may be hard to do; just wishful I guess. Any attempt at this, or an improvement, would be greatly appreciated, as this stuff is beyond me.
Thanks!

Hi JapanDave,

No, no copying of lessons onto other sheets.
Just copying parts of lessons (or a whole lesson) to the next date downward in the same sheet.
I'm making an attempt to plan out an entire semester in this format, so most of the dates and plans will be there.
Lesson plans for an entire semester will extend vertically in only one sheet.

What I was trying to describe was an automated way to manage the rows in a lesson block or range.
What I was envisioning was having 6 different events, some of which would apply to just a row that a lessonitem was in (#s 1-4), one that would apply to an entire lessonplan for one day (#5), and one that would insert a template lessonplan (#6) for a day to be selected.

Imagine that, as a class, we may only be able to get through 3 or 4 topics for a day instead of 6 or 7 topics that I had planned for that day. Well, I'd then need to update the plans for the next day. It'd just be nice to automate this through clicking a button or cell, like in col C. This is probably going to be too difficult to progam...

Good idea,
The attached sheet shows how the rows could maybe be moved and appended to the next day's lesson.