Transferring corresponding cell formula when sorting one column by order A to Z?

[mrsbee]

I have a spreadsheet with ten sheets. Each sheet isdedicated to specific client expenses (rent, postage, copies, faxes, etc.). Whena value is entered on one of these sheets for a client, the formula (for thatcell) is set up to transfer the data to the corresponding client on the firstsheet (Totals).
I’ve been tasked to alphabetize each sheet according to theclient names (Column A). The sort function works great for the names, but notthe data (the formula remains with the specified cell).
Is there any way to sort the Column A on each sheet (byorder A to Z) and transferring its corresponding formula at the same time?

 

[mrsbee]

Example: I am using the formula "=+Rent!D6" forCompany M to transfer all data on all the other sheets from Column D, Row 6.But now that Company M has been alphabetized/sorted, it is now on Row 10--thedata won't transfer because the formula is still telling the data to go to Row6.
I could do it manually, but there are 15 columns and 119clients. =|