(* excel_setnameofsheet.applescript *)

tell application "Microsoft Excel"
    set name of sheet 1 to "New Sheet Name 1"
    set name of sheet 2 to "New Sheet Name 2"
    set name of sheet 3 to "New Sheet Name 3"
end tell