Automating input to a new worksheet

[Brent]

I entering information - with a one to many relationship so to speak. ie
one state has 6 to 30 behaviors etc. The problem is that the many cell
becomes to bulky and large when looking at the information.

So I created another worksheet.

Now what I want is to link the behavior cell in one worksheet to the data of
the behavior in cell of the other worksheet with the ability to dynamicaly
manipulate ( ie add,delete,move etc) and not loose the link between the
states their behaviors.

Any Ideas?

I am sure that a database more applicable for this, but I do not have the
time or experience etc..