Automatic updating from one worksheet to another...
 

I have a workbook that contains 4 worksheets. Two worksheets contain
consumers under the age of 60, the other two are for consumers over the age
of 60. Right now I have the DOB column conditionally formatted to change to
green when it is 18 months from their 60th birthday, blue when it is 12
months, and red when it is 4 months.

Is there any way to have Excel automatically transfer their information to
the over 60 worksheet, or do I have to do it manually?

Also, is there any way at all to sort the sheet even if some of the cells in
the row may be locked?