i am working with a worksheet in the following way

column A through F have been linked with the corresponding columns in another workbook. columns G through J contain data that i have to fill in manually. For example A1 contains the name of a client (link) and G1 contains transportation means. the problem is, however, that i trace errors whenever i sort records (data). rows containing data in columns A through F remain correct, but the same rows contain errors in columns G through J contain errors. data in the same row get mixed up. Am i doing something wrong or is it impossible to work with a <<partially linked worksheet

please help me solve this problem!!!