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?