I have a workbook, with multiple worksheets. Sheet 1 is my master sheet. The other sheets have links to the table in Sheet 1. The reason is so that I can change data in Sheet 1, and the calcualtions in the other sheets will reflect those changes.

I am wanting to sort the data in Sheet 1 without loosing my links in the other sheets. I am able to cut and insert rows in Sheet 1 and the links are maintained to the correct cells, but when I try to sort the rows, the data link is not maintained. Im sure it is a simple setting, but I don't know how or where to find it. Thanks.