I have an assignment tracker. The data is in 9 columns (A-I). Everything is
in a list
and I want it to stay that way. What I want to happen though is that every
time
a new row is added to the Worksheet "Master" is that worksheets called
different names are populated with the same information in the same
format,just in the different worksheet, at the bottom of the list, but also
in a list. All the columns are data columns from A to I. Coloumn A is a
Hyper link manually input and I would like it to stay a hyperlink after it is
copied over. The Name is always entered in coloumn I. Currently there are 8
other name worksheets, but more may be added later.

So is there a way to say if row X column I in worksheet "Master" is "Tom"
then worksheet "Tom" will have the next available row(next available) = row X
from "Master"?
Where row X is the newly input data in worksheet "Master"