Change the jobs to Overwrite only, not Append Else Overwrite
Then, if the job re-uses the tape each week, change the OPP (Overwrite Protection Period) to 6 days for that media set, if you reuse tapes every other week, change the OPP to 13 days, etc.
BackupExec should now reuse the tapes with no intervention from you