Macro inserts new template worksheet tap between First and Last tab. Inserted worksheet is renamed as a Job Number. Job number not known until after insert. Need help with a formula that can count the occurrences of all sheets between first:last, without yet knowing the inserted sheet name(s).
Solved by K. E. in 14 mins