I would like to know that how can I sort one sheet and accordingly get other
sheets to sort with it.

Problem being faced:

USing 8 Sheets which referenced to each of the previous sheet based on the
value of one of the columns in that previous sheet,

ex: This is the formula I am using in one of the columns of sheet 2
"=IF('Cutting or Slitting'!N2=0,0,'Cutting or Slitting'!J2)"

this sheet is named RG and the next sheet is referenced to RG as
"=IF(RG!F2=0,0,RG!A2)"

Now the problem is that I need to sort the data in shee1 (Cutting or
Slitting) but whenever I do that the correspnding reference in the next sheet
changes too and whcih results in changing of orientation of the rows in the
sheet which was not sorted.

In a nutshell sorting the main sheet also sorts the referenced cells of a
particular sheet but does not sort it according to the rows of that sheet.

Hope sbd undersands my problem and replies soon.

Thanks anyway