DATA FOLLOWING SORTS
 

I have a multi-page workbook. The first page containes the master client data
in 5 columns. The other 12 pages (one for each month) containes both the
master data (transfered using the following formula; =IF('MASTER
LIST'!B3<"",'MASTER LIST'!B3,"") ). There are then additional columns where
data is entered for each client. When a new client is added to the master
list at the bottom and then alpha sorted. While the master data sorts on the
other pages, the entered data does not follow the client. How can this be
repaired?