Hi all. I have a master spreadsheet with all the clients' trade
information and need to link information between the master sheet and
other separate worksheets containing the trade info for each
individual client. For example, on the master sheet, it lists every
client's quantity, price, stock, and date of each trade she made;
there is also a separate sheet for, say, client A which lists only
her quantity, price, stock, and date of each trade.

Here is what I want to do: Not only do I want to have the data in the
individual sheet updated as I update the master sheet's corresponding
data, I also want to see the new entry (of quantity, price, etc.)
automatically added to the individual sheet as I add new data on the
master sheet, or vice versa. For example, client A made a trade today,
and I record the data of the trade into the master sheet, I also want
to see the data appear on her individual sheet. I know about the
Sheet1! cell reference thing, but apparently it doesn't work if I want
to add a new entry simultaneously the individual sheet as I update the
master sheet. I heard you have to it by playing with macros and even
visual basic. What exactly should I do to make this happen?

Thank you very much!