Paste Link then Data Sort

[Richard Horn]

Just ran into a snag. In my workbook I have 4 Quarterly Project tabs and 1
Summary tab to consoildate project status throughout the year. I am using
Paste Link to the Summary tab from each of the Quarterly Project tabs,
however, if we use the Data Sort feature on any one of the Quarterly Project
tabs to view the data sorted by a different column, (i.e., Organization,
Status, Project Lead), it completely messing up the Summary page. Is there
anything that I can use to prevent this?

 

[Dave Peterson]

If you use simple links like:
=sheet1!x99
you'll have this problem when you sort your data.

If it's possible, maybe you can match on a unique key and use that key to
retrieve the value you want--maybe using =vlookup() or =index(match()).