You can only use Excel data validation on one sheet at a time. You must set up the rules on each sheet individually to use it in more than one sheet.