I'm creating an excel database for a clinical study on patients with
migraine. Each patients will treat 4 attacks (episodes). This
presents a bit of a problem, since there's some information I'm
collecting that's specific to the patient (demographic information like
sex, height, etc.), and some that is specific to each attack (like the
pain level of that attack, the duration of that attack, etc.). To
account for this, I decided to give each patient four rows--one for
each attack--and I put their deomographic information in the second
row, leaving the other three blank in those fields (see below).

However, this lead to complications when I was programming the
statistics, so I ended up making a new worksheet for each attack
(worksheets "Attack 1", "Attack 2", "Attack 3", and "Attack 4", in
addition to the original "All Data" worksheet). These worksheets have
all the attack-specific information for each patient. For example, the
attack 1 worksheet would be the first row of each patient (i.e. every
4th row, starting with row 2) from column 5 on (i.e. skipping the
demographic stuff).

I don't know how many patients there will be, so I'd like for the user
to be able to add new patients (rows) to the All Data worksheet and
have it automatically update the other worksheets. Is there a way to
do this other than manually going to every single row in each Attack
worksheet and typing "=" and the referenced cell number? Also, if I
have to manually do this, I'll just have to pick a random number of
patients to do it for (i.e. some large number that I don't they'll go
over) instead of catering to the specific number of patients in the
"All Data" worksheet.

(Note: In the example worksheet below, a cell with just "----"
indicates a blank cell. The "--" are just place holders for me to try
to line things up)

| Sex | Height | Age | Weight | Attack | Pain | Duration | Etc . . . .