Cell References
 

I have about 116 worksheets in a workbook. The first
sheet (called MACRO_INTERFACE) has a list of report names
on it and the remaining worksheets have data for those
reports. Each sheets has a cell reference to the main
sheet to show the name of the report listed on the main
sheet (looks like =MACRO_INTERFACE!B6) The problem I am
having is that every time I sort the list on the main
sheet, the references change and I get the wrong report
names shown on the sheets. How can I keep the cell
references from changing when I do a sort?

~Jenny