Good Afternoon,

I use Excel 2003 in Win XP.

I am creating a spreadsheet that includes multiple "CTRL + L" lists for the
purposes of scheduling concerts.  

The lists are:
1.  pieces to be performed
2.  musicians involved
3.  rehearsal times
4.  Tasks to complete

When I add items to a list, it takes up a row beneath.  

My question:
Is there a way to set up the list so that it INSERTS a NEW row instead of
taking the row below?  Thus, when I add to a list it pushes the other stuff
down.  This way there is not unused space that I must reserve for each list.  

I'd like to avoid leaving unnecessary blank rows.

I'm a newish excel user.  I carefully read other posts and the help files
without finding an answer.  Apologies if I'm asking a redundant question!  I
read info about INDEX, and "dynamic ranges" with no luck.  

Thanks,
Brighella.